Get Active records - slowly changing dimension type 2

Question

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?

Answer 1

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.