| Other Data Warehouse General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are CUBES? | | 2 |
| What is a star schema? Why does one design this way? | | 3 |
| what is the difference between etl tool and olap tools | | 3 |
| What is up date strategy and what are th options for update
strategy? | | 2 |
| What are Data Marts? | | 2 |
| 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 |
| why oracle is the best database for data warehousing? | HCL | 2 |
| 4.Explain Snowflkeschema ? | HCL | 6 |
| What is META DATA information in Data warehousing projects? | IBM | 1 |
| How can you define a transformation? What are different
types of transformations in Informatica? | TCS | 4 |
| What is Bulk Insert? | | 3 |
| how can one connect two fact tables ? is it possible ? how? | ABC | 7 |
| When should one use an MD-database (multi-dimensional
database) and not a relational one? | IBM | 1 |
| What is query panel? | | 1 |
| Explain in simple terms, the concept of Data Mining. | | 2 |
| What is the difference between a W/H and an OLTP application? | | 4 |
| What is the difference between an ODS and a W/H? | | 1 |
| wht is degenerated dimension ?it's uses? | CTS | 8 |
| What Oracle features can be used to optimize my Warehouse
system? | | 1 |
| What is XMLA ? | | 1 |
| |
| For more Data Warehouse General Interview Questions Click Here |
Site Map
