1. write a SQL query to identify the employee with second largest salary 2. write a query to remove duplicate records in a table 3. explain SCD type 2 mapping
Informatica Developer Interview Questions
653 informatica developer interview questions shared by candidates
1. dataware housing concepts : difference between OLTP/OLAP ,difference between Fact/Dim 2. Informatica : difference between lookup/Joiner,types of tranformations , more on lookup and file loading 3. Database : how to delete dups from table, Cross join function , difference between delete/truncate ,difference between intersect/inner join, query approch 4. Informatica scenarios : read bulls raider for the same
Quais são as suas experiências anteriores?
Preguntas relacionadas al perfil cómo, años de experiencia, proyectos en los que participaste, dónde trabajaste anteriormente, áreas de oportunidad, etc...
All basic infotmatica question performance tuning SQL queries SCD
what is snow flake schema
what is Start schema
Remove duplicates in SQL, SCD type 2 flow, Dynamic lookup, Department wise highest salary query in SQL, How to consider list of files in Informatica PC
Basic Informatica concepts, PLSQL, UNIX
Informatica scenario based questions and data warehousing concept
Viewing 451 - 460 interview questions