| Other Data Warehouse General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to use the tool Ontobulider | | 1 |
| which automation tool is used in data warehouse testing? | | 1 |
| What is data merging, data cleansing and sampling? | | 1 |
| What is MDX? | TCS | 1 |
| What is a Data Cube? | | 1 |
| What is confirmed dimension? | | 3 |
| What is Bulk Insert? | | 3 |
| Can you explain how analysis service works? | | 1 |
| What is up date strategy and what are th options for update
strategy? | | 2 |
| how do you use commit frequencies? how does it affect
loading performance? | | 1 |
| how can one connect two fact tables ? is it possible ? how? | ABC | 6 |
| explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF
ORACLE 8I | IBM | 1 |
| How can you define a transformation? What are different
types of transformations in Informatica? | TCS | 3 |
| what is the difference between aggregate table and fact
table ? how do you load these two tables ? | Target | 10 |
| What is Data purging? | TCS | 4 |
| What is DTS ? | | 1 |
| difference between bo 6.5 and bo xi r2 | Accenture | 1 |
| What is ?Data Warehousing?? | | 2 |
| 1.WHAT IS DATA MART ? | HCL | 1 |
| What is Time Series algorithm in data mining? | | 1 |
| |
| For more Data Warehouse General Interview Questions Click Here |