| 66 | 16 Sep 2013 @ 07:32 PDT | Database | Topic | Aggregate 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 ... |
| 65 | 12 Sep 2013 @ 06:35 PDT | Database | Reply | Why 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... |
| 64 | 06 Sep 2013 @ 05:48 PDT | Database | Reply | Need 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... |
| 63 | 06 Sep 2013 @ 01:40 PDT | Database | Topic | Why 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... |
| 62 | 04 Jul 2013 @ 09:46 PDT | Analytics | Reply | Cardinality : Populate missing/non-existent elements | Could you please explain again what u need ? not very clear.
|
| 61 | 04 Jul 2013 @ 09:36 PDT | Analytics | Topic | Design change / Perf Optimization Suggestion required | Table: 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... |
| 60 | 04 Jul 2013 @ 09:34 PDT | Database | Topic | Design change / Perf Optimization Suggestion required | Table: 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... |
| 59 | 18 Jun 2013 @ 10:05 PDT | Database | Topic | #Records estimation for Derived tables. " Too many rows" error | HI 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... |
| 58 | 28 Feb 2013 @ 07:07 PST | Database | Reply | Index traversal forbidding the use of Partitions | We 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
... |
| 57 | 28 Feb 2013 @ 06:01 PST | Database | Reply | Index 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 (... |
| 56 | 28 Feb 2013 @ 05:58 PST | Database | Reply | Index traversal forbidding the use of Partitions | Yes. 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... |
| 55 | 28 Feb 2013 @ 04:32 PST | Database | Reply | Index traversal forbidding the use of Partitions | DIeter - 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... |
| 54 | 28 Feb 2013 @ 04:03 PST | Database | Reply | Index 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... |
| 53 | 28 Feb 2013 @ 01:16 PST | Database | Reply | Index traversal forbidding the use of Partitions | Yes 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... |
| 52 | 27 Feb 2013 @ 11:56 PST | Database | Topic | Index traversal forbidding the use of Partitions | I 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... |
| 51 | 08 Nov 2012 @ 04:32 PST | Data Modeling | Reply | What 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... |
| 50 | 04 Oct 2012 @ 05:13 PDT | Database | Reply | CREATE 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.
|
| 49 | 05 Sep 2012 @ 06:52 PDT | Database | Topic | Partition 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 ... |
| 48 | 23 Jul 2012 @ 01:55 PDT | Database | Reply | Statistics 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... |
| 47 | 29 Jun 2012 @ 03:25 PDT | General | Reply | Grouping 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... |
| 46 | 27 Jun 2012 @ 01:25 PDT | Database | Reply | Can 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... |
| 45 | 14 Jun 2012 @ 03:26 PDT | Database | Topic | Dynamic 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... |
| 44 | 05 Jun 2012 @ 08:48 PDT | Database | Reply | Need 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... |
| 43 | 05 Jun 2012 @ 09:35 PDT | Database | Topic | Need help with some handy code for this situation |
Data In Table
COL1 COL2 Start End
A B ... |
| 42 | 11 Apr 2012 @ 11:11 PDT | Database | Reply | Sum column values based on date range |
The Week01 is repeating for all the cases after "then"
|