Asked me questions in technologies ETL Informatica, Oracle SQL PLSQL, Business Objects, Unix, Linux,Autosys, Domain related questions 1.What is ETL process? How many steps ETL contains? 2.What is Full load & Incremental or Refresh load? - ETL 3.What is a three tier data warehouse? - ETL 4.What are snapshots? What are materialized views & where do we use them? What is a materialized view log? - ETL 5.What is partitioning? Explain about Round-Robin, Hash partitioning. - ETL 6.What is partitioning? Explain about Round-Robin, Hash partitioning. - ETL 7.What is a mapping, session, worklet, workflow, mapplet? - ETL 8.What is Operational Data Store? - ETL 9.When do we Analyze the tables? How do we do it? - ETL 10.How to fine tune mappings? - ETL 11.What are the differences between Connected and Unconnected lookup? - ETL 12.When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between Stop and Abort - ETL 13.What is tracing level? How many types of transformations supported by sorted input? - ETL