DataSense

I am often asked usually by programmers - What is Data Warehousing & how do I learn it? I explain to them we use all the same tools that you do but differently. That’s when I coined the term Data Sense. It describes the essence of Data Warehousing and separates Data Warehousing from rest of Programming. Every aspect of IT from Hardware / Software infrastructure to Design, Development and QA is done with massive data flows and need for data precession accuracy and meaning.

Sunday, February 18, 2007

Rules for creating Dimensions

  • Dimensions are entities - not attributes. So a dimension called tick_type is silly.
  • Dimensions don’t talk to other Dimensions.
  • Every attribute of the dimention belongs to the entity only.
  • If there needs to be a link between two Dimensions create a bridge table .
  • If there are too many bridge tables combine them to be a factless fact table.
Posted by at