How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE

5 Answers   Informatica,


What is primary and backup node?

0 Answers  


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?

3 Answers   CTS, Wipro,


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

4 Answers   IBM,


How many joins in Informatica

5 Answers   CSC,






Where is the cache stored in informatica?

5 Answers   Infosys, Satyam,


Which are the different editions of informatica powercenter that are available?

0 Answers  


By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

14 Answers   CSC, Emphasis,


Enlist few areas or real-time situations where informatica is required.

0 Answers  


I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

6 Answers   Mastek,


How you prepared reports for OLAP?

0 Answers  


suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers   ITC Infotech, TCS,


Categories