CONCEPTS AND ARCHITECTURE Data Warehouse Interview Questions [31 Questions]

  1. How do we maintain Primary key in Fact Table ?is there any option other than Surrogate key or concatenated key?
  2. Database triggers in DWHHow do you manage the database triggers in DWH?
  3. Loading data from DatamartsWhich approach is better and why?Loading data from datamarts to datawarehouse or vice versa?
  4. What is Critical key, Complex key?
  5. What is the difference between choosing a multidimensional database and a relational database?

  6. You must first Login or Register to view all 31 questions from this category.


    Registering yourself is FREE, takes just less than a minute and opens up a whole new GetGyan experience.