Informatica questions
Informatica Developer Interview Questions
294 informatica 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.
Panelists were not available for the whole process, I have to sit before the System hoping from someone to join for 4 hours.
Average technology specific questions on Informatica PC, UNIX, SQL, Snowflake.
Hive related and informatica related questions
How to delete partition in hive
What would be the one thing you would change about your work? Have you done something about it?
DWH concepts like late arriving dimension.
Informatica scenarios were given to solve and mainly focused on Caches nd lookups.
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 101 - 110 interview questions