| Other Data Warehouse General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the difference between OLAP, ROLAP, MOLAP and HOLAP? | | 2 |
| 5.Explain ODS ? | HCL | 3 |
| Where can one get more info about Data Warehousing? | TCS | 2 |
| How Materialized Views are linked with Oracle DataWare
house? | Kirloskar | 1 |
| What is MDX? | TCS | 1 |
| What is aggregate awareness? | | 2 |
| What is Bulk Insert? | | 3 |
| What is operational data source (ODS)? | | 2 |
| What are CUBES? | | 2 |
| Which kind of index is preferred in DWH? | | 1 |
| What is Drill by? drill through? | iFlex | 1 |
| 2.What is staging area ? | HCL | 3 |
| what is a hot file, why we need in datawarehousing, where
we used in general | Thomson | 2 |
| What is mapplet? | | 1 |
| what are the types of dimension tables | Infotech | 9 |
| What Oracle features can be used to optimize my Warehouse
system? | | 1 |
| What is a star schema? Why does one design this way? | | 3 |
| How can we do ETL process in SQL Server? | ETL | 1 |
| explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF
ORACLE 8I | IBM | 1 |
| What is up date strategy and what are th options for update
strategy? | | 2 |
| |
| For more Data Warehouse General Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
