| Other Data Warehouse General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| why oracle is the best database for data warehousing? | HCL | 2 |
| What is difference between Business Objects and Hyperion
Essbase? Please help me | | 1 |
| what is parallelism? | | 1 |
| What is the difference between an ODS and a W/H? | | 1 |
| How can Oracle Materialized Views be used to speed up data
warehouse queries? | | 3 |
| difference between For each and for all | | 1 |
| What is Bulk Insert? | | 3 |
| What is IQD file? | | 1 |
| what are the similarities between ROLAP and MOLAP | | 1 |
| What is DTS ? | | 1 |
| What is the difference between Oracle Express and Oracle
Discoverer? | | 1 |
| what is query optimizer? what are different types of
optimizer s supported by oracle ? | ABC | 1 |
| What is surrogate key? | IBM | 4 |
| wht is degenerated dimension ?it's uses? | CTS | 8 |
| When should you use a STAR and when a SNOW-FLAKE schema? | Accenture | 5 |
| What is Conceptual, Logical and Physical model? | | 1 |
| What are cursors? | | 4 |
| What is factless fact schema? | | 1 |
| Difference between DSS & OLTP? | IBM | 4 |
| How to handle time period attribute for time dependent data??
a.)add time period as a part of pk b.)add time period simply
and make it nullablec.)add time period simply and make it
not null. | | 1 |
| |
| For more Data Warehouse General Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
