| Other Data Warehouse General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is MDX? | TCS | 1 |
| What is operational data source (ODS)? | | 1 |
| Which kind of index is preferred in DWH? | | 1 |
| what is data validation strategies for data mart validation
after loading process | | 1 |
| what is the difference between aggregate table and fact
table ? how do you load these two tables ? | Target | 10 |
| What is up date strategy and what are th options for update
strategy? | | 2 |
| How does data mining and data warehousing work together? | | 2 |
| What is Data purging? | TCS | 4 |
| What is factless fact schema? | | 1 |
| what is query optimizer? what are different types of
optimizer s supported by oracle ? | | 1 |
| What are Data Marts? | | 2 |
| What is aggregate awareness? | | 2 |
| What is a look up function? What is default transformation
for the look up function? | | 1 |
| Where can one get more info about Data Warehousing? | TCS | 2 |
| Hierarchy of DWH? | Accenture | 1 |
| How can we import and export using BCP utility? | | 1 |
| How can you define a transformation? What are different
types of transformations in Informatica? | TCS | 3 |
| difference between For each and for all | | 1 |
| What is Snow Flake Schema design in database? | | 2 |
| Why do we use DSS database for OLAP tools? | | 2 |
| |
| For more Data Warehouse General Interview Questions Click Here |