This post describes the different useful Data Warehouse terms which are closely associated with Kimbal Data Warehousing approach. Measure It is a numeric value in reporting and analysis. Example: Price,Balance or Inventory. Measures come from data sources. Measure is characterized by grain. Dimension A dimension is a collection of related values called members. example: 2008 is a member of Time...
Importance of Data Warehousing and its Design
This post explains about what Data warehousing is and why we should care about it and then speaks about importance of using in enterprises and its design. It is important to understand the what data warehousing is all about, As a database developer you are likely to be involved with Data warehousing in one way or the other. Data Warehousing Defined: Data warehousing is a methodological approach...