top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Get Active records - slowly changing dimension type 2

0 votes

i have created slowly changing dimension type 2 mapping in informatica mapping designer and i want to get active records from the loaded historical data with out using date,flag & version?

posted Feb 9, 2015 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

To maintain SCD type 2, different people take different approaches. For example, one approach is to add effective and expiration dates to indicate a time period during which the record was active. If the expiration date is NULL it indicates the current active record. Another approach is to add one column to indicate the current active record. Normally people use the first approach or a combination of both.

answer Feb 11, 2015 by Shweta Singh