Olap vs oltp.. Start snowflake.. Different type of dimension table.. View vs mv.. Proc vs fucn
Etl Informatica Developer Interview Questions
126 etl informatica developer interview questions shared by candidates
Data flow
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
related to the previous work experience domain related questions ETL design
nothing they have asked
Very basic SQL queries
Little insight of your current 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?
Questions related to Informatica Power center, sql queries
Viewing 111 - 120 interview questions