suppose in my source flatfile i have 10000 records in that
some of master table records missed table records missed
then what will u do


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

Post New Answer

More Informatica Interview Questions

What are the parts of Informatica Server?

1 Answers   Cognizant,


Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

0 Answers   IBM,


What is a passive transformation?

0 Answers   Informatica,


What is the main difference between a Joiner Transformation and Union Transformation?

5 Answers  


What is union transformation?

0 Answers  






What are the Advantages of de normalized data?

3 Answers  


From where we can start or use pmcmd?

3 Answers  


Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers   Zensar,


Explain your project of banking domian.

0 Answers   Cap Gemini,


&#61656; Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers   DELL,


source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks

4 Answers   Polaris,


can any one give some examples for pre sql and post sql(Except dropping and creating index).

0 Answers   Zensar,


Categories