Briefly describe lookup transformation?


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

Post New Answer

More Informatica Interview Questions

Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,


define galaxy repository in informatica

0 Answers  


How to load data in informatica ?

0 Answers  


hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you

5 Answers   Patni,


What is checksum termnology in informatica? Where do you use it ?

3 Answers   Chase, Cognizant, Deloitte,






i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers   TCS,


How are parameters defined in informatica?

3 Answers   HP, TCS,


how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

0 Answers   CTS,


How do you recover rows from a failed session

1 Answers  


write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,


what is the Default Source Option For Update Strategy Transformation?

0 Answers   Informatica,


how to use incremental load?

2 Answers   TCS,


Categories