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.
Experiencia idiomas y virtudes m
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.
Domande sul percorso di studi, sulla tesi della laurea, e altre esperienze lavorative.
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.
Viewing 281 - 290 interview questions