Olap vs oltp.. Start snowflake.. Different type of dimension table.. View vs mv.. Proc vs fucn
Senior Informatica Etl Developer Interview Questions
126 senior 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
Very basic SQL queries
Little insight of your current project
Data flow
Different transformations,SQL queries and Scd types along with session properties.
Viewing 111 - 120 interview questions