Systems In Motion Senior Consultant interview questions

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