How to achieve SCD Type 2 in informatica, mention all the transformations used ?

Question

Accepted Answer

SCD Type 2 in Informatica can be achieved using multiple transformations.

Use a Source Qualifier transformation to read data from the source.
Use an Expression transformation to derive new columns or modify existing ones.
Use a Lookup transformation to look up data in a reference table.
Use a Router transformation to route data to different targets based on conditions.
Use a Filter transformation to filter out unwanted data.
Use a Sequence Generator transformation to generate surrogate keys.
Use a Union transformation to combine data from multiple sources.
Use a Sorter transformation to sort data before loading into targets.
Use a Update Strategy transformation to flag records as insert, update or delete.
Use a Target table to store the data.

Top CAMSDATA Technologies India Software Engineer interview questions & answers