Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 24 Jun 2009 @ 14:03:04 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Partitioning Start_Date End_Date pair for Dimensions
 
From:   Goli, Srikanth

Hi -

I am looking at partitioning options for a dimension table (Type 2 SCD) with StartDate and EndDate fields for tracking valid periods for a record. For the same natural key, we only generate one system key, and as any attribute of the record changes, existing record is expired (with EndDate = current day - 1) and a new record added with current date as the start date and infinite date (year 9999) as the end date (standard SDC 2 operation). Current requirement for presentation is to show "as was" values of the record; so joins happen with the fact table on fact record date falling between Start and End dates of the dimension record.

The dimension table seems to be getting fairly large; so I am looking to see if we can partition this table. Does it help if I partition on Start Date or End Date or Start and Dates?


Thanks.



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016