What are the different Lookup methods used in Informatica?


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

Post New Answer

More ETL Interview Questions

Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?

5 Answers  


Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?

2 Answers  


What are snapshots?

0 Answers  


what are the session parameters? How do u set them?

0 Answers  


Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)

2 Answers   Cognizant, IBM,


Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10

0 Answers   Cap Gemini,


Is hadoop a etl tool?

0 Answers  


What is initial load and what is full load?

0 Answers  


When do we analyze the tables?

0 Answers  


how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

1 Answers  


List few etl bugs?

0 Answers  


what are the parts of Informatica server ?

1 Answers   GE,


Categories