| Other Data Warehouse General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Where can one get more info about Data Warehousing? | TCS | 2 |
| How can we do ETL process in SQL Server? | ETL | 1 |
| 1.WHAT IS DATA MART ? | HCL | 4 |
| What is Factless fact table? In which purpose we are using
this in our DWH projects?Plz give me the proper answer.
Thanks,
Ramesh
| ACS | 6 |
| what is the difference between DSS and ODS ? | Satyam | 2 |
| Tell me one example for junk dimension? | TCS | 3 |
| Business rule implemntation depends on?
1.)ETL requiremnts 2.)ETL performance
3.)business requirements. | | 2 |
| how can one connect two fact tables ? is it possible ? how? | ABC | 7 |
| Difference between ODS and Staging | TCS | 3 |
| explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF
ORACLE 8I | IBM | 1 |
| What is a star schema? Why does one design this way? | | 3 |
| Why do we use DSS database for OLAP tools? | | 2 |
| Give me a broad concept of what a data warehouse is, and
what it might be used for? | | 2 |
| Tell me one example for multi valued dimension or bridge
table? | TCS | 2 |
| DWH architecture? | | 4 |
| What is Snow Flake Schema design in database? | | 2 |
| What is surrogate key? | IBM | 4 |
| What is the "junk dimension"? Give with examples? | | 7 |
| wht is degenerated dimension ?it's uses? | CTS | 8 |
| Hi,
Could any one tell me which schema (star and snow flake
schema) will take much space?
Thanks
S.A.K
| Accenture | 3 |
| |
| For more Data Warehouse General Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
