| Other Data Warehouse General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is the use of surrogate key in businessobjects | | 1 |
| What is META DATA information in Data warehousing projects? | IBM | 1 |
| What is Molap and Rolap? What is Diff between Them? | | 2 |
| What is aggregate awareness? | | 2 |
| how can one connect two fact tables ? is it possible ? how? | ABC | 6 |
| What Oracle tools can be used to design and build a W/H? | | 1 |
| What is the "junk dimension"? Give with examples? | | 3 |
| How can we import and export using BCP utility? | | 1 |
| what is query optimizer? what are different types of
optimizer s supported by oracle ? | | 1 |
| what is a hot file, why we need in datawarehousing, where
we used in general | Thomson | 1 |
| What is a Data Cube? | | 1 |
| Hierarchy of DWH? | Accenture | 1 |
| How can you define a transformation? What are different
types of transformations in Informatica? | TCS | 3 |
| Explain in simple terms, the concept of Data Mining. | | 2 |
| Difference between ODS and Staging | TCS | 1 |
| What is operational data source (ODS)? | | 1 |
| what is the difference between aggregate table and fact
table ? how do you load these two tables ? | Target | 10 |
| What is the difference between OLAP, ROLAP, MOLAP and HOLAP? | | 2 |
| What is surrogate key? | IBM | 4 |
| What is the difference between a data warehouse and a data mart? | | 7 |
| |
| For more Data Warehouse General Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
