1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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....

Question Posted / mini


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

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

1 Answers   IBM,

In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

1 Answers   iNautix,

Which development components of informatica have the highest usage?

0 Answers  

There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?

1 Answers   Wipro,

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,




my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced

9 Answers  

While importing the relational source defintion from database,what are the meta data of source U import?

1 Answers  

My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers   HP,

What could be the possible resons of locks by user?

0 Answers  

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers  

How you can differentiate between connected lookup and unconnected lookup?

0 Answers  

Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories