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

In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?

2 Answers  


What is CHECK-IN CHECK-OUT. Please explane me?

3 Answers   TCS,


What are the components of the workflow manager?

1 Answers  


Is it possible to define a single node as a Gateway node as well as worker node?

1 Answers  


how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1 Answers   CTS,


What is mapplet in informatica?

1 Answers  


Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.

1 Answers   iGate,


insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files

1 Answers  


How can you generate reports in informatica?

1 Answers  


What are active and passive transformations?

1 Answers   Informatica,


If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  


In a table, 4 person having same salary. How to get Third person record only?

15 Answers  


Categories