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.
Fui questionada sobre exemplos da aplicação da experiência.
Experiência e exemplos de desafios e soluções
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
Hive related and informatica related questions
qual sua pretensão salaria para o cargo?
Viewing 271 - 280 interview questions