Hi gurus can any one tell me with a flow how to implement SCD
Type 1 and SCD Type 2 in a single mapping.For some fields SCD
type has to be implemented and for some fields scd type has to
be implementd..Thank in advance....



Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single ma..

Answer / kiran ghatage

You will find this in following examples...
https://community.informatica.com/solutions/mapping_implementing_scd1_using_md5
https://community.informatica.com/solutions/mapping_scd_type_2_effective_date
https://community.informatica.com/solutions/mapping_scd_type_2_versioning

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

Why the UNION TRANSFERMATION is an Active TRANSFERMATION

6 Answers   Emphasis,


I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.

3 Answers   Amdocs,


Explain the difference between a data warehouse and a data mart?

0 Answers  


What are the unsupported repository objects for a mapplet?

1 Answers   Informatica,


In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.

2 Answers   TCS,


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

0 Answers   TCS, Wipro,


How to fix the etl bugs..Tell me the process?

1 Answers   IBM,


Explain target update override in informatica

0 Answers   Informatica,


what is the command to get the list of files in a directory in unix?

5 Answers   iGate,


3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

7 Answers   TCS,


Is LOAD MANAGER AND LOAD BALANCER same in informatica?

1 Answers   KPIT,


How can we eliminate duplicate rows from flatfile,explain?

3 Answers  


Categories