| Other Data Warehouse General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Explain in simple terms, the concept of Data Mining. | | 2 |
| What is subject area? | | 2 |
| where exactly in dataware house a confirmed dimension can
be created | Deloitte | 2 |
| what are the similarities between ROLAP and MOLAP | | 1 |
| What is Conceptual, Logical and Physical model? | | 1 |
| What is factless fact schema? | | 1 |
| Tell me one example for junk dimension? | TCS | 3 |
| What are CUBES? | | 2 |
| how can one connect two fact tables ? is it possible ? how? | ABC | 7 |
| What is the difference between an ODS and a W/H? | | 1 |
| what is query optimizer? what are different types of
optimizer s supported by oracle ? | ABC | 1 |
| what is the difference between DSS and ODS ? | Satyam | 2 |
| Give me a broad concept of what a data warehouse is, and
what it might be used for? | | 2 |
| What is up date strategy and what are th options for update
strategy? | | 2 |
| which automation tool is used in data warehouse testing? | | 1 |
| What is Bulk Insert? | | 3 |
| What is confirmed dimension? | | 5 |
| Advantages of de normalized data? | | 2 |
| What is difference between a connected look up and
unconnected look up? | | 1 |
| three ways sql*loader could load data, what are those three
types? | | 1 |
| |
| For more Data Warehouse General Interview Questions Click Here |