#DateForumTypeThreadPost
6616 Sep 2013 @ 07:32 PDTDatabaseTopicAggregate Join Indexes - Implementation suggestion reqd I have a requirement to create an AJI (Partitioned on Shipment_Dt) with 120 Weeks of Data. Could you please suggest the best way to implement that based on your experiences. 1. Keep the dimension ...
6512 Sep 2013 @ 06:35 PDTDatabaseReplyWhy the Optimiser does not run these STATS in parallel ?Thanks Dieter, But could you please suggest any way to do this in a faster manner. I need to calculate these Ranks to calculate the Store Selling Metric which is non additive across the Product Hie...
6406 Sep 2013 @ 05:48 PDTDatabaseReplyNeed Analytical window query help Select IDR , STATUS , CASE WHEN STATUS = PREV_STATUS THEN 0 ELSE 1 END AS STATUS_CHANGE_IND , START_DT FROM ( Select IDR , Status , COALESCE(MAX(STATUS) OVER (PARTITION BY IDR ORDER B...
6306 Sep 2013 @ 01:40 PDTDatabaseTopicWhy the Optimiser does not run these STATS in parallel ?I am ranking my Product Level Data on the basis of higher grains of Products (Product=>BrandFamily=>Category=>Manufacturer). If all the Rank functions are indeoendent then Why Teradata doe...
6204 Jul 2013 @ 09:46 PDTAnalyticsReplyCardinality : Populate missing/non-existent elementsCould you please explain again what u need ? not very clear.
6104 Jul 2013 @ 09:36 PDTAnalyticsTopicDesign change / Perf Optimization Suggestion requiredTable: RETAIL_SHIPMENT / Records - 7 Billion / Partitions  - 120 Weekly Partitions  Table: CURR_YAGO_CAL - Has Weekend Dates and their Corresponding Year Ago Dates. Sample 2 records...
6004 Jul 2013 @ 09:34 PDTDatabaseTopicDesign change / Perf Optimization Suggestion requiredTable: RETAIL_SHIPMENT / Records - 7 Billion / Partitions  - 120 Weekly Partitions  Table: CURR_YAGO_CAL - Has Weekend Dates and their Corresponding Year Ago Dates. Sample 2 records...
5918 Jun 2013 @ 10:05 PDTDatabaseTopic#Records estimation for Derived tables. " Too many rows" errorHI All,   We are facing a very frustrating problem in our reporting warehouse. We have given an adhoc BO universe to the business users. Users make their choices and execute the reports. Som...
5828 Feb 2013 @ 07:07 PSTDatabaseReplyIndex traversal forbidding the use of PartitionsWe are in the process of cleaning up unused NUSIs and I will surely consider your inputs for other tables as well. But the issue still stands with the BMSMS thing   Thanks for all the help ...
5728 Feb 2013 @ 06:01 PSTDatabaseReplyIndex traversal forbidding the use of Partitions  Forgot this:)     PARTITION BY RANGE_N(Shipment_Dt  BETWEEN DATE '2007-01-01' AND DATE '2020-12-31' EACH INTERVAL '7' DAY ) INDEX (...
5628 Feb 2013 @ 05:58 PSTDatabaseReplyIndex traversal forbidding the use of PartitionsYes. Shipment date is both Partitioned and It has a NUSI as well. Is it a right way or it dosen't makes sense  as even I was bit surprised to see this but hard to convince all the colleagu...
5528 Feb 2013 @ 04:32 PSTDatabaseReplyIndex traversal forbidding the use of PartitionsDIeter - Plan wise, second one more efficient but its taking 4 secs without PROD_ID filter whereas the first one is takinf almost 6 mins. Unfortunately I can not access DBQL tables. Regarding BMS...
5428 Feb 2013 @ 04:03 PSTDatabaseReplyIndex traversal forbidding the use of Partitions  I am on TD 13   Given below are the Explains without and with the PROD_ID Filters. Can you please help me understand why Teradata is creating a Bit map even in the cases whe...
5328 Feb 2013 @ 01:16 PSTDatabaseReplyIndex traversal forbidding the use of PartitionsYes Dieter, Shipment_Dt is used in the Where condition as well. And it uses the Partition elimination when the Condition commented below is removed from the query.  I don't understand why...
5227 Feb 2013 @ 11:56 PSTDatabaseTopicIndex traversal forbidding the use of PartitionsI have a 8 billion record Shipments table which is joined to couple other tables. The Shipments tables has some indexes defined and those index columns are being used as filters in my query. The Sh...
5108 Nov 2012 @ 04:32 PSTData ModelingReplyWhat is a building block approach to building semantic data models?I absolutely agree with sbarreda. Semantic layers are a great way of isolating the load process than the usage of the data which is generally designed together :( A 3NF data model gives better perf...
5004 Oct 2012 @ 05:13 PDTDatabaseReplyCREATE TABLE Failed. 3933: The Maximum Possible Row Length in the Table is too Large.Also depends upon the max Data Block size set by the DBA since a table row has to completely fit inside a Data Block.
4905 Sep 2012 @ 06:52 PDTDatabaseTopicPartition Elimination not happening in Fact through Time Dimension filter. Hi Folks, I have a case in my Reporting Layer where a huge fact is accessed be passing filters through the time dimension.The Problem I am facing is that when I give a single date filter in ...
4823 Jul 2012 @ 01:55 PDTDatabaseReplyStatistics on Primary Index Hashing output of Col1 and col2 columns separately would always be different from the combined HASH output of (Col1,col2) so in my opinion the Combined stats would be more relevant for the optmi...
4729 Jun 2012 @ 03:25 PDTGeneralReplyGrouping Contiguous Data Hi, Could anyone let me know what is the meaning of this error I am getting while trying to run the TD_NORMALIZE_OVERLAP_MEET     Cannot determine the best-fit function...
4627 Jun 2012 @ 01:25 PDTDatabaseReplyCan we use GROUPING ,GROUPING_ID,Grouping Sets Krishna,   You can go through the below chapter to clear your thoughts about GROUPING SETS: ==>SQL Reference Data Manipulation Statements ====>Chapter: The SELECT Stat...
4514 Jun 2012 @ 03:26 PDTDatabaseTopicDynamic Partitioning not happening for multiple dates through BO Folks, I have a Fact surrounded by many dimensions out of which calendar is one and the Fact along with joining to other dimensions does joins to this calendar dimension as well to fetch dat...
4405 Jun 2012 @ 08:48 PDTDatabaseReplyNeed help with some handy code for this situation OK. Here is the situation. The data is regarding the effectivity of col2 for Col1 for a eff_st and eff_end date range. I have just used integers in place of dates for simplicity. I h...
4305 Jun 2012 @ 09:35 PDTDatabaseTopicNeed help with some handy code for this situation Data In Table COL1    COL2    Start    End A          B       ...
4211 Apr 2012 @ 11:11 PDTDatabaseReplySum column values based on date range The Week01 is repeating for all the cases after "then"

Pages