| Other Data Warehouse General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 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 the difference between aggregate table and fact
table ? how do you load these two tables ? | Target | 10 |
| Advantages of de normalized data? | | 1 |
| Hierarchy of DWH? | Accenture | 1 |
| Explain in simple terms, the concept of Data Mining. | | 2 |
| what is data validation strategies for data mart validation
after loading process | | 1 |
| What is the difference between a W/H and an OLTP application? | | 4 |
| what is the use of surrogate key in businessobjects | | 1 |
| What Oracle features can be used to optimize my Warehouse
system? | | 1 |
| What is the capacity of power cube? | | 1 |
| What is Data purging? | TCS | 4 |
| What is the difference between an ODS and a W/H? | | 1 |
| What are cursors? | | 4 |
| What is staging area? | | 6 |
| 5.Explain ODS ? | HCL | 1 |
| What is source qualifier? | | 1 |
| how can one connect two fact tables ? is it possible ? how? | ABC | 6 |
| DWH architecture? | | 3 |
| which automation tool is used in data warehouse testing? | | 1 |
| 4.Explain Snowflkeschema ? | HCL | 1 |
| |
| For more Data Warehouse General Interview Questions Click Here |