tables created for master data

by Calvin on June 10, 2008

tables created for master data

a. P table - Time independent master data attributes

b. Q table - Time dependent master data attributes

c. M view - Combines P and Q

d. X table - Interface between master data SIDs and time independent navigational attributes SIDs ( P is linked to the X table)

e. Y table - Interface between master data SIDs and time dependent navigational attributes SIDs (Q is linked to the Y table)

{ 0 comments }

Nine decision points of data warehousing

by Calvin on June 7, 2008

Nine decision points of data warehousing

  • Identify fact table
  • Identify dimension tables
  • Define attributes of entities
  • Define granularity of the fact table (how often
  • Pre calculated key figures
  • Slowly changing dimensions
  • Aggregates
  • How long data will be kept
  • How often data is extracted

{ 0 comments }