| Other Data Warehouse General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are Data Marts? | | 2 |
| Give me a broad concept of what a data warehouse is, and
what it might be used for? | | 2 |
| What is aggregate awareness? | | 2 |
| Difference between DSS & OLTP? | IBM | 2 |
| What is a star schema? Why does one design this way? | | 2 |
| Why do we use DSS database for OLAP tools? | | 2 |
| What is staging area? | | 6 |
| Tell me one example for multi valued dimension or bridge
table? | TCS | 1 |
| wht is degenerated dimension ?it's uses? | CTS | 8 |
| What are cursors? | | 4 |
| What is an OLAP (On-line Analytical processing) system? | | 1 |
| wat is code review and wat actually srs or how can we
create HLD,LLD.PLS,GIVE ME ANSWER AS EARLY AS FAST. | | 1 |
| difference between For each and for all | | 1 |
| How can we import and export using BCP utility? | | 1 |
| Can you explain how analysis service works? | | 1 |
| What is surrogate key? | IBM | 4 |
| difference between bo 6.5 and bo xi r2 | Accenture | 1 |
| What is the difference between Oracle Express and Oracle
Discoverer? | | 1 |
| what is data validation strategies for data mart validation
after loading process | | 1 |
| What is factless fact schema? | | 1 |
| |
| For more Data Warehouse General Interview Questions Click Here |