lookup transformation with screenshots


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

Post New Answer

More Informatica Interview Questions

While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?

4 Answers  


Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,


How we can use union transformation?

0 Answers  


What is confirmed dimension?

3 Answers  


I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,






How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

2 Answers   Mphasis,


If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,


Explain how to import oracle sequence into informatica?

0 Answers  


How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,


What differs when we choose the sorted input for aggregator transformation?

0 Answers  


Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

8 Answers   HP,


How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,


Categories