| Other Data Warehouse General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are CUBES? | | 2 |
| If I have table T1 and table T2
T1 has 250 cols and 10,000 rows
T2 has 2 billion rows and 10 cols
Which one would be Fact table and which one would be
Dimension table and why ? | Principal-Finance | 3 |
| if we increase the number of dimensions will the rows in
fact table increase or decrease?? | IBM | 3 |
| What is Time Series algorithm in data mining? | | 2 |
| How can we do ETL process in SQL Server? | ETL | 1 |
| Tell me one example for junk dimension? | TCS | 3 |
| When should one use an MD-database (multi-dimensional
database) and not a relational one? | IBM | 1 |
| what are the types of dimension tables | Infotech | 9 |
| What is the capacity of power cube? | | 1 |
| What is BCP? | | 1 |
| What is staging area? | | 7 |
| What Oracle tools can be used to design and build a W/H? | | 1 |
| 2.What is staging area ? | HCL | 3 |
| What is ?Data Warehousing?? | | 2 |
| How can Oracle Materialized Views be used to speed up data
warehouse queries? | | 3 |
| which automation tool is used in data warehouse testing? | | 1 |
| What is XMLA ? | | 1 |
| What is up date strategy and what are th options for update
strategy? | | 2 |
| what is the difference between etl tool and olap tools | | 3 |
| What is query panel? | | 1 |
| |
| For more Data Warehouse General Interview Questions Click Here |
Site Map
