Dataware Housing Interview Questions(ETL, Business Intelligence,Abinitio)

General :

1. What is a data-warehouse?
2. What are Data Marts?
4. What is ER Diagram?
5. What is a Star Schema?
6. What is Dimensional Modelling?
7. What is Snow Flake Schema?

ETL Questions:
1. What is a staging area? Do we need it? What is the purpose of a staging area?
2. What is a three tier data warehouse?
3. What are the various methods of getting incremental records or delta records from the source systems?

Business Intelligence:
1. What is Business Intelligence?
2. What is OLAP?
3. What is OLAP, MOLAP, ROLAP, DOLAP, HOLAP? Examples?

Abinitio:

1.What is the function you would use to transfer a string into a decimal?
2.How many parallelisms are in Abinitio? Please give a definition of each.
3.What is the difference between a DB config and a CFG file?

Want More questions.... . We have more then 3000 questions in the exclusive EFS Repository