Type 2 method tracks historical data by creating multiple records. It writes a record with the new attribute information and preserves a record of the old dimensional data.
Example: Employee table with following structure
Employee_ID - Employee identification Employee_Name - Name of Employee Employee_GroupID - Group to Which Employee Belongs Employee_typeID - Contractor/Permanent/Temporary Employee_Country - Country Effective_Start_dt - Record Start date when record was created Rec_End_dt - Effective End Date when record get expired also for existing record it could be NULL or '2999-12-31'
Hai anand, You explained SCD Type 2 method with example very well . but how to implement the same in Mload script ? already i checked this solution given in the below link . http://forums.teradata.com/forum/tools/scd-type-2-in-mload#comment-14717
Please provide me the working Mload script . Thanks in Advance.