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
Que tipo de problemas has resuelto teniendo en cuenta que tu estás a cargo de un área.
What is ETL process
Questions related to database modelling
Indexing, Data cleaning, aggregate functions
-Analytical Sql queries -General sql questions -Perfomance tuning -ETL scenario qeustoin.
DWH Concepts, ETL Techniques, Performance tuning and others.
database mentioned in the cv
Describe Yourself
Informatica scenario based questions and data warehousing concept
Viewing 511 - 520 interview questions