| Other Data Warehouse General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| When should one use an MD-database (multi-dimensional
database) and not a relational one? | IBM | 1 |
| What is up date strategy and what are th options for update
strategy? | | 2 |
| What is Conceptual, Logical and Physical model? | | 1 |
| What is a star schema? Why does one design this way? | | 3 |
| what is the use of surrogate key in businessobjects | EDS | 3 |
| what is table partitioning? How it is useful to warehouse
database? | EDS | 1 |
| How to handle time period attribute for time dependent data??
a.)add time period as a part of pk b.)add time period simply
and make it nullablec.)add time period simply and make it
not null. | IBM | 1 |
| Hi,Please can u tell me..
What is the difference between a Hyperion Essbase CUBE and
a Star Schema?
Thanks in advance,
Vijay. | iFlex | 1 |
| What is Bulk Insert? | | 3 |
| wht is degenerated dimension ?it's uses? | CTS | 8 |
| Select * from emp,dept,loc where emp.deptno left outer join
dept.deptno and dept.locno=loc.locno.
No need to consider the syntax but is it possible to have
left outer join and equi join in the same SQL like this ?
can we have right outer join and left outer join in the
same SQL --- | Principal-Finance | 1 |
| Tell me one example for multi valued dimension or bridge
table? | TCS | 2 |
| What's a Cube in Rolap? | Oracle | 2 |
| 4.Explain Snowflkeschema ? | HCL | 6 |
| Business rule implemntation depends on?
1.)ETL requiremnts 2.)ETL performance
3.)business requirements. | | 2 |
| 5.Explain ODS ? | HCL | 3 |
| What is a Data Cube? | | 1 |
| 3.What is fact less fact ? | HCL | 5 |
| difference between For each and for all | | 1 |
| What is aggregate awareness? | | 2 |
| |
| For more Data Warehouse General Interview Questions Click Here |
Site Map
