| Other Data Warehouse General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is staging area? | | 6 |
| What is MDX? | TCS | 1 |
| how do you use commit frequencies? how does it affect
loading performance? | | 1 |
| What is Time Series algorithm in data mining? | | 1 |
| What is the difference between an ODS and a W/H? | | 1 |
| what is a hot file, why we need in datawarehousing, where
we used in general | Thomson | 1 |
| wat is code review and wat actually srs or how can we
create HLD,LLD.PLS,GIVE ME ANSWER AS EARLY AS FAST. | | 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 query panel? | | 1 |
| What is the capacity of power cube? | | 1 |
| what is data validation strategies for data mart validation
after loading process | | 1 |
| When should one use an MD-database (multi-dimensional
database) and not a relational one? | | 1 |
| 1.WHAT IS DATA MART ? | HCL | 1 |
| Tell me one example for multi valued dimension or bridge
table? | TCS | 1 |
| What is source qualifier? | | 1 |
| What is difference between a connected look up and
unconnected look up? | | 1 |
| 4.Explain Snowflkeschema ? | HCL | 1 |
| DWH architecture? | | 3 |
| What is ?Data Warehousing?? | | 2 |
| What is Bulk Insert? | | 3 |
| |
| For more Data Warehouse General Interview Questions Click Here |