Olap vs oltp.. Start snowflake.. Different type of dimension table.. View vs mv.. Proc vs fucn
Informatica Etl Developer Interview Questions
126 informatica etl developer interview questions shared by candidates
1. In depth knowledge in Index 2. What are all dB check needs to do for informatica partition 3.dynamic lookup scenario 4. Getting data from Different time zone how to load single table 5.explain plan how to see 6.SQL query taking time to run what else db check needs to do...
Basic questions like : LookUp, SCD, Database
complex mapping in your project
What do you mean by 3NF in DBMS? What is the operating system? What is the difference between Java and C++? What is a pointer? Tell us more about the pointer. Write about double-linked list programs. What is Join in DBMS?
related to the previous work experience domain related questions ETL design
Data flow
Different transformations,SQL queries and Scd types along with session properties.
All transformations, performance tuning, transformations based problem statement, sql queries
Interview questions included regarding my technical experience
Viewing 111 - 120 interview questions