What are the challenges you have faced in your Project (DWH-
ETL)? Explain with example?


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

Post New Answer

More Informatica Interview Questions

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com

6 Answers   HCL, Schneider,


What is InformaticaPowerCenter?

0 Answers   Informatica,


Router T/R is active but some people are saying it is also passive which is exactly right?

5 Answers  


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

8 Answers   DELL,


Why we use ENABLE HIGH PRECISION in session properties?

2 Answers   Cognizant,






What are the types of lookup?

3 Answers   Wipro,


what is degenerated dimension table with scenario

2 Answers   HCL,


how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?

2 Answers   emc2,


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

0 Answers  


How to elaborate powercenter integration service?

0 Answers  


Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....

2 Answers  


One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

0 Answers   TCS,


Categories