Scenario based questions on Informatica that uses Aggregator and Expression Transformations
Informatica Etl Developer Interview Questions
728 informatica etl developer interview questions shared by candidates
Difference between Pandas Dataframe and Numpy Araay?
This is a written exam with no multiple-choice or true/false questions. there were very basic-advanced T-SQL development questions - like text-book questions - dmvs, indexing, keys, define a relational db… Nothing to do with the job requirements- 0 ETL or BI questions. They asked 2-3 questions where you will need to revise and create code.
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.
Viewing 471 - 480 interview questions