What would be the one thing you would change about your work? Have you done something about it?
Informatica Ontwikkelaar Interview Questions
294 informatica ontwikkelaar interview questions shared by candidates
DWH concepts like late arriving dimension.
Basic
All scenario based questions not a single straight forward question. Year wise sales data to be loaded in the target , load only positive sales data. If a source file has parent child relationship how will you load each file for different parents. Interview was very tough as interviewer was expecting answers in detail.
How did you impliment SCD type 2 in your project.
What are your career goals and how can Accenture help you achieve that?
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.
Informatica questions
How to delete partition in hive
Average technology specific questions on Informatica PC, UNIX, SQL, Snowflake.
Viewing 101 - 110 interview questions