Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

Typical artifact in data warehouse model

Here are data warehouse table types:

  • Fact table
  • Dimension table
  • Dimension Hierarchy – Column Flattening table
  • Dimension Hierarchy – Row Flattening table
  • Mini-Dimension table
  • Aggregate table
  • Helper table
  • Lookup Table – Providing multiple language and code support
  • Cross Reference table

The above are the tables used in the BI queries.

There are also tables designed for ETL.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s