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

What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?

1 Answers   Altisource, Patni,

Explain the etl program with few examples.

0 Answers  

what is the difference between stop and abort?

3 Answers   TCS,

Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,

What is the use of transformation?

0 Answers  




How many number of sessions that u can create in a batch?

3 Answers  

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

0 Answers  

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

0 Answers  

For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

0 Answers  

I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com

2 Answers   DELL, iGate,

How is union transformation utilized?

0 Answers  

For more Informatica Interview Questions Click Here
Categories