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
Why do you want to work here?
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
What is your background? Why did you major in x/y/z?
I honestly don't remember any.
Preguntas relacionadas al perfil cómo, años de experiencia, proyectos en los que participaste, dónde trabajaste anteriormente, áreas de oportunidad, etc...
What type of student were you in university?
They asked me how my background matched what they were looking for in this role.
Scd types, transformations and scenario based questions,
Informatica scenario based questions and data warehousing concept
Viewing 791 - 800 interview questions