#DateForumTypeThreadPost
11229 Jan 2010 @ 08:58 PSTUDATopic'Pre-Built' dimensionI am trying to understand the concept of a pre-built dimension.The following DDL exemplifies my problem:-- Step 1 - Create the staging table.CREATE SET TABLE marc_centlook ,NO FALLBACK ,NO BEFORE J...
11121 Oct 2009 @ 08:04 PDTUDAReplyA bit of mathermaticsFYI I think this algorithm will work apart from the first examples where the TS and RQ cross over which gives me another option:seq_id / 100 as TS;seq_id mod 100 as RS;
11006 Oct 2009 @ 06:58 PDTUDAReplyA bit of mathermaticsThanks Pawan - exactly what I was thinking. Oh well it wasn't critical anyway, I have an alternative just not a mathematical one.
10906 Oct 2009 @ 06:20 PDTUDATopicA bit of mathermaticsHi.I have a formula to calculate a unique transaction sequence number that works as follows:transaction sequence(TS) * 100 + record sequence(RS)So take two examples:118(TS) * 100 + 103(RS) = 119039...
10814 Aug 2009 @ 11:40 PDTUDATopicOne to ManyHey.I am doing a proof of concept and have come unstuck, my design is as below and I believe this design could work but am not sure how. However I admit my design may be incorrect for the data stru...
10724 Jul 2009 @ 04:02 PDTUDAReplyRankThanks Guys.
10623 Jul 2009 @ 10:57 PDTUDATopicRankHey.I have a dataset as can be setup below. I want to assign a sequential integer values to a group of related data. However rank doesn't do exactly what I want but is very close. I'm wondering doe...
10530 Sep 2008 @ 04:38 PDTUDAReplyTable DesignThere is obviously more processing involved when running a multi-table join even using PIs but this does not necesarily mean it has to be slower.Investigate:1) Can you balance the data across the a...
10430 Sep 2008 @ 04:24 PDTUDATopicSearching what table indices are used.Is there a way of identifying what indices are actively/regulary used on a table?I have 13Gb of indices on a FACT table and when I remove them all my ETL is slightly faster but some of my troubleso...
10330 Sep 2008 @ 06:30 PDTUDATopicDropping table indices - Data PagesI was wondering if I drop indices on a table(100million rows) without dropping & rebuilding the table will it leave large white spaces on the data pages that could impact performance negatively?
10231 Mar 2008 @ 07:30 PDTUDAReplyAggregate & Case-- this is how. SELECT sum(CASE WHEN Year_id = 2008 THEN (CAST((COALESCE(f_basic_premium * F_exch_rate,0)) AS NUMERIC(18,6))) END), sum(CASE WHEN Week_id = 200749 THEN (CAST((COALESCE(f_ba...
10131 Mar 2008 @ 06:37 PDTUDATopicAggregate & CaseI need to remove the Year_Id in the where clause and include it in the CASE stmt for performance reasons. I'm merging alot of code into 1 statement and this is my first go at this.However, I'm sele...
10028 Mar 2008 @ 10:36 PDTUDATopicCOUNT and GROUP BY Stmt when SELECT returns zero.SELECT count(distinct a.claim_ref_id)INTO :v_RepClaimsTWFROM fat_bse_cl_pay_cre_trans aJOIN prt_lu_product bON (a.product_id = b.product_id)WHERE (a.Reported_date_id between '2007/12...
9926 Mar 2008 @ 11:40 PDTUDATopicCase Statement Variable.Can a variable be used inside a case statement like so:SELECT (CASE WHEN Year_id = :v_Year_id THEN 1 END)FROM ......
9810 Mar 2008 @ 08:30 PDTUDATopicPerformance TuningI am trying to reduce this Query's runtime by 50% or more!I've tried a number of things...INSERT INTO MARC_MCGUCKIAN.Rec_Clm_Est_WH_CT1 (policy_id, policy_desc, claim_ver_id, claim_code_desc, regio...
9728 Feb 2008 @ 10:53 PSTUDAReplyMicrostrategy on TeradataI seemed to be able to do this as follows: I would love to be able to filter out the idle processes but cannot find a table holding it yet you can see the AMP and PE status "IDLE" in Pmon. Any idea...
9606 Feb 2008 @ 10:40 PSTUDATopicFastLoad ErrorLimitHow do you view the current value and how can I configure it.I have a fastload integer value coming from the source system of 360 penalty points.The destination table has a penalty point field of D...
9505 Feb 2008 @ 10:19 PSTToolsTopicFastload ErrorLimitHow do you view the current value and how can I configure it.I have a fastload integer value coming from the source system of 360 penalty points.The destination table has a penalty point field of D...
9423 Jan 2008 @ 12:13 PSTUDATopicSlow CoalesceI have a very slow query(generated by microstrategy!!) that joins a very large table to a group of very small volatile tables as follows:...join TableA a112on (coalesce(pa11.Client_id, pa...
9317 Jan 2008 @ 07:17 PSTUDAReplyAggregationThanks."Strange" - Yes I thought so too.So I thought why not test it anyway as I didn;t think it was valid.I have an idea on paper from someone else(that I don't fully understand yet hence this pos...
9216 Jan 2008 @ 04:02 PSTUDATopicAggregationUPDATE marc SET m2 = sum(m1) + sum(m2) WHERE m1 = 1;What is a practical solution to this?
9109 Jan 2008 @ 05:06 PSTUDATopicMicrostrategy on TeradataWhen Microstrategy runs a report schedule on Teradata, does it hit the database anywhere else apart from the specific data warehouse tables being queried? In other words are any syatem tables maint...
9006 Dec 2007 @ 06:20 PSTUDATopicLinux - BTEQ - OLE LoadI call bteq from Linux in my application alot.I am wondering if there is a way of wrapping another utility around the OLE Load to make it dynamic or whether I can somehow call it directly?I am tryi...
8906 Dec 2007 @ 06:19 PSTToolsTopicBTEQ & OLEI call bteq from Linux in my application alot.I am wondering if there is a way of wrapping another utility around the OLE Load to make it dynamic or whether I can somehow call it directly?
8812 Nov 2007 @ 11:47 PSTUDAReply3813: The positional assignment list has too many valuesmy error handler DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN CALL sp_lo_insert_log(0, :v_i_run_job_id, :v_proc_name, 'ERROR', 'SQL_STATE: ' || CAST(:SQLSTATE AS VA...

Pages