Career Center Interview NotesDataware 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
|
:upset i\'m really confused with the links available.... pls help me how to download the interview questions |
|
You need to go through the extended registration to get access to full version of the database which is called EFS Repository. |
|
i am very confusing to download DWH e-book Please help me to download DWH Qusions and if it need to register how it is??????????? |
| whats advantage with data ware housing |
