Informatica Etl Developer Interview Questions

208 informatica etl developer interview questions shared by candidates

1) Three session are used, if session 1 completed session 2 has to start and once session 2 completed session 3 has to start. It should be sequential. 2) how do you compare two files in unix. 3) mechanism how diff command works. 4) 3 i/p used say A B C in aggregator, and the o/p should be as A & B, B & C, C & A. How do you design the mapping. 5) In Sorter transformation 10 i/p is used, if group by port is not marked, what would be the o/p.
avatar

Informatica Developer

Interviewed at Cognizant

3.5
May 14, 2016

1) Three session are used, if session 1 completed session 2 has to start and once session 2 completed session 3 has to start. It should be sequential. 2) how do you compare two files in unix. 3) mechanism how diff command works. 4) 3 i/p used say A B C in aggregator, and the o/p should be as A & B, B & C, C & A. How do you design the mapping. 5) In Sorter transformation 10 i/p is used, if group by port is not marked, what would be the o/p.

how many mapping you have done ? what kinds of mapping ? how complex mapping you have done? how do cleanse the data facts and dimensions tables procedure,package and functions used in previous projects explain with business scenerios few more questions from both
avatar

Oracle Developer With Informatica

Interviewed at BBVA

3.9
Sep 18, 2017

how many mapping you have done ? what kinds of mapping ? how complex mapping you have done? how do cleanse the data facts and dimensions tables procedure,package and functions used in previous projects explain with business scenerios few more questions from both

Viewing 61 - 70 interview questions

See Interview Questions for Similar Jobs

Glassdoor has 208 interview questions and reports from Informatica etl developer interviews. Prepare for your interview. Get hired. Love your job.