| Other Data Warehouse General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is Bulk Insert? | | 3 |
| What is query panel? | | 1 |
| Which kind of index is preferred in DWH? | | 1 |
| Explain about Control M JObs detaily?How to execute this. | Scope-International | 2 |
| What is data merging, data cleansing and sampling? | | 1 |
| Tell me one example for multi valued dimension or bridge
table? | TCS | 1 |
| Can you explain how analysis service works? | | 1 |
| What is surrogate key? | IBM | 4 |
| 3.What is fact less fact ? | HCL | 2 |
| When should one use an MD-database (multi-dimensional
database) and not a relational one? | IBM | 1 |
| 1.WHAT IS DATA MART ? | HCL | 1 |
| What is a Data Warehouse? | | 7 |
| What is an OLAP (On-line Analytical processing) system? | | 1 |
| how do you use commit frequencies? how does it affect
loading performance? | | 1 |
| explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF
ORACLE 8I | IBM | 1 |
| which automation tool is used in data warehouse testing? | | 1 |
| Where can one get more info about Data Warehousing? | TCS | 2 |
| What is a Data Cube? | | 1 |
| what is data validation strategies for data mart validation
after loading process | | 1 |
| What is a look up function? What is default transformation
for the look up function? | | 1 |
| |
| For more Data Warehouse General Interview Questions Click Here |