Archives of the TeradataForum

Message Posted: Wed, 25 May 2011 @ 09:47:13 GMT

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

Hi Alan,

Based on my assumption, am providing the below suggestions. Please correct if my assumption is wrong.

The business logic in your dwh(SCD-2) is designed to capture the changes in any of first 3 fields and creates the new row Which means that the latest record would be marked as high end date(31/12/2999).

Thanks

John

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