| Other Data Warehouse General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are CUBES? | | 2 |
| What is the difference between Oracle Express and Oracle
Discoverer? | | 1 |
| Hierarchy of DWH? | Accenture | 1 |
| 2.What is staging area ? | HCL | 1 |
| What is difference between Business Objects and Hyperion
Essbase? Please help me | | 1 |
| What is confirmed dimension? | | 3 |
| What is XMLA ? | | 1 |
| What is Data purging? | TCS | 4 |
| When should you use a STAR and when a SNOW-FLAKE schema? | Accenture | 5 |
| what is a hot file, why we need in datawarehousing, where
we used in general | Thomson | 1 |
| How Materialized Views are linked with Oracle DataWare
house? | Kirloskar | 1 |
| what are different ways of loading data to data warehouse
using oracle? | | 1 |
| How can we import and export using BCP utility? | | 1 |
| What is the difference between OLAP, ROLAP, MOLAP and HOLAP? | | 2 |
| What is a star schema? Why does one design this way? | | 2 |
| suppose data are coming from different locations and those
data will not change . is there any need to use surrogate key ? | Oracle | 3 |
| 3.What is fact less fact ? | HCL | 2 |
| three ways sql*loader could load data, what are those three
types? | | 1 |
| what are different types of partitioning in oracle ? | | 2 |
| How to use the tool Ontobulider | | 1 |
| |
| For more Data Warehouse General Interview Questions Click Here |