Archives of the TeradataForum
Message Posted: Wed, 24 Jun 2009 @ 14:03:04 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|