Slowly changing dimensions, types and where will you use them


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

Post New Answer

More Informatica Interview Questions

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,


Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc

10 Answers   Cap Gemini, IBM,


Explain transaction control transformation in informatica

0 Answers   Informatica,


Does an informatica transformation support only aggregate expressions?

0 Answers  


What is a pre-defined event and user-defined event?

0 Answers  






Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  


What is a snowflake schema?

0 Answers  


what is confirmed fact?

2 Answers  


111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers   IBM,


I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,


How can u stop a batch?

2 Answers  


how many repositories can v create in informatica .

3 Answers   Cap Gemini, Tech Mahindra,


Categories