Previous | Page 5 of 8 | Next

Business Model: ODWT

Example: Access Method & Account

• Access Method & Account are created as a separate dimension. Even though most of the case Access method will be child to Account. Both dimension has single hierarchy as show in the figure below

  

• Access Method Logical table consists of Logical table sources. Each Logical Table source corresponds to a Physical table collapsing snowflake physical table in to one logical Dimension table

  

• Attributes of Access Method/Account Logical table

  

Previous | Page 5 of 8 | Next