| Other Data Warehouse General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is a hot file, why we need in datawarehousing, where
we used in general | Thomson | 1 |
| What is mapplet? | | 1 |
| What is a star schema? Why does one design this way? | | 2 |
| What is ?Data Warehousing?? | | 2 |
| 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 aggregate awareness? | | 2 |
| What is Data purging? | TCS | 4 |
| What is subject area? | | 2 |
| explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF
ORACLE 8I | IBM | 1 |
| When should you use a STAR and when a SNOW-FLAKE schema? | Accenture | 5 |
| What is a look up function? What is default transformation
for the look up function? | | 1 |
| What is Drill by? drill through? | iFlex | 1 |
| what is the difference between DSS and ODS ? | Satyam | 2 |
| wat is code review and wat actually srs or how can we
create HLD,LLD.PLS,GIVE ME ANSWER AS EARLY AS FAST. | | 1 |
| what is query optimizer? what are different types of
optimizer s supported by oracle ? | | 1 |
| What is the difference between a W/H and an OLTP application? | | 4 |
| What is staging area? | | 6 |
| What is up date strategy and what are th options for update
strategy? | | 2 |
| What is Snow Flake Schema design in database? | | 2 |
| What are CUBES? | | 2 |
| |
| For more Data Warehouse General Interview Questions Click Here |