Asked about the project, implementation level questions and real time scenarios
Informatica Interview Questions
653 informatica interview questions shared by candidates
About project and my roles and resoinsibilites
1.scd type2with effective date2. about session3. SCD type3 scenarios 4. data warehousing concepts 5.star and snow flake schema6. about my current project 7. transformations scenarios
1. Normalizer transformation 2. How do you read from message queues in Informatica? 3. Scenarios for oracle SQL's and Informatica logic
Star schema , snow flakes scheme, joins, transformations.
how to run the workflow in unix commands and what type of shell script you written.
Self introduction. Difference between look up and unconnected lookup. Types of scds. Brief discription of scds. Joins used in lookup's.
It was started with "tell me about your self" followed by technical questions on informative, oracle,Unix,odi,dataware housing and end to end process of project
complete technical followed by HR
Endereço e como é o trajeto até chegar a etec
Viewing 381 - 390 interview questions