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

if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,


Can you copy the session to a different folder or repository?

1 Answers  


how may sources can be used in a mapping at a time?(limit)

6 Answers   IBM,


if i have a delimited file as source so how can we seperate this file into three diff targets?

2 Answers   TCS,


Explain how to import oracle sequence into informatica?

0 Answers  






there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

4 Answers  


difference between shortcut and reusable transformation?

2 Answers  


Can we make worklet inside worklet?

1 Answers  


what is the hint? how to use it to reduce the query processing in program?

3 Answers   Cegedim,


hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE

2 Answers  


TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

6 Answers   HP, TCS,


have you developed documents in your project? and what documents we develop in realtime?

2 Answers   IBM,


Categories