Archives of the TeradataForum

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

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

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>>