What is meant by lookup transformation?


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

Post New Answer

More Informatica Interview Questions

why do we go for update strategy tr in SCD rather using the session properties?

3 Answers   IBM,


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,


if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,


In which circumstances that informatica server creates Reject files?

2 Answers  


how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  






How will you update the row without using update statergy?

10 Answers   CTS,


How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

3 Answers   Logica CMG,


There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)

4 Answers  


How an expression transformation differs from aggregator transformation?

0 Answers  


Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks

4 Answers   IBM,


Can we create a Integration service without a Repository service and vice versa?

0 Answers  


Which one is better performance wise connected/un-connected lkp?why?

2 Answers   HCL, TCS,


Categories