| Other Data Warehouse General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is surrogate key? | IBM | 3 |
| How can you define a transformation? What are different
types of transformations in Informatica? | TCS | 3 |
| What is Molap and Rolap? What is Diff between Them? | | 2 |
| What is a Data Warehouse? | | 7 |
| how do you use commit frequencies? how does it affect
loading performance? | | 1 |
| What is the "junk dimension"? Give with examples? | | 3 |
| Explain in simple terms, the concept of Data Mining. | | 2 |
| What is the difference between OLAP, ROLAP, MOLAP and HOLAP? | | 2 |
| What is a Data Cube? | | 1 |
| What is staging area? | | 6 |
| 3.What is fact less fact ? | HCL | 2 |
| Tell me one example for junk dimension? | TCS | 3 |
| Advantages of de normalized data? | | 1 |
| explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF
ORACLE 8I | IBM | 1 |
| What is mapplet? | | 1 |
| which automation tool is used in data warehouse testing? | | 1 |
| what are the types of dimension tables | | 6 |
| What is Bulk Insert? | | 3 |
| three ways sql*loader could load data, what are those three
types? | | 1 |
| What is Conceptual, Logical and Physical model? | | 1 |
| |
| For more Data Warehouse General Interview Questions Click Here |