| Other Data Warehouse General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Tell me one example for multi valued dimension or bridge
table? | TCS | 1 |
| suppose data are coming from different locations and those
data will not change . is there any need to use surrogate key ? | Oracle | 3 |
| What is a Data Cube? | | 1 |
| What is a star schema? Why does one design this way? | | 2 |
| What is mapplet? | | 1 |
| difference between bo 6.5 and bo xi r2 | Accenture | 1 |
| What is ETL process in Data warehousing? | | 2 |
| What are Data Marts? | | 2 |
| What is operational data source (ODS)? | | 1 |
| What is difference between a connected look up and
unconnected look up? | | 1 |
| What is data merging, data cleansing and sampling? | | 1 |
| What is factless fact schema? | | 1 |
| How Materialized Views are linked with Oracle DataWare
house? | Kirloskar | 1 |
| Can you explain how analysis service works? | | 1 |
| how can one connect two fact tables ? is it possible ? how? | ABC | 6 |
| what is indexing ? what are different types of indexes
supported by oracle ? | | 2 |
| What is source qualifier? | | 1 |
| what is the difference between DSS and ODS ? | Satyam | 2 |
| Why do we use DSS database for OLAP tools? | | 2 |
| What is the difference between a data warehouse and a data mart? | | 7 |
| |
| For more Data Warehouse General Interview Questions Click Here |