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
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?