Q1) In a traditional Relational Database, we normalize tables to 3rd normal form, eliminating redundancy. However, in our Data Warehouse we denormalize tables for a few reasons. Discuss these reasons in detail.
Q2) Roll up and Drill down and slicing and dicing allow analysts to conceive of data as a cube with hierarchical dimensions leads to conceptually straightforward operations to facilitate analysis. Data can be analyzed across multiple dimensions, as opposed to two dimensions across an x and a y axis. How are multiple dimensions for an enterprise to examine their data.
Q3) Big Data is another term that people are rather loose with, experiencing the concept in a variety of ways. How has the development of the concept of Big Data impacted the world of the Data Warehouse?
Q4) Hadoop has developed over the last decade as an alternative to the traditional Data Warehouse. How has Hadoop evolved to complete the Data Warehouse. What does Hadoop do differently that has made a true alternative platform to the Data Warehouse.