 |
 |
Archives of the TeradataForum
Message Posted: Wed, 24 Jun 2009 @ 15:58:49 GMT
| Subj: | | Re: Partitioning Start_Date End_Date pair for Dimensions |
| |
| From: | | Victor Sokovin |
| | 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? | |
I'd say SI is / are probably a better option here than partitioning.
Victor
| |
