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
Informatica Etl Developer Interview Questions
208 informatica etl developer interview questions shared by candidates
Asked about the project, implementation level questions and real time scenarios
About project and my roles and resoinsibilites
Star schema , snow flakes scheme, joins, transformations.
how to run the workflow in unix commands and what type of shell script you written.
1. Normalizer transformation 2. How do you read from message queues in Informatica? 3. Scenarios for oracle SQL's and Informatica logic
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
What version of Informatica power center tool in used in your project.
Viewing 101 - 110 interview questions