Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: OLAP function and tracking data changes
From:   Jepamony, Johnpaul

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



  <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: 15 Jun 2023