Home > Uncategorized > MS BI Workshop #12 – General design tips for dimension tables

MS BI Workshop #12 – General design tips for dimension tables

This is my last notes on dimension modeling.

  • Avoid unnecessary normalizing. In a star schema, the practice of normalizing is called snowflaking. This is usually unnecessary, unless your dimension tables is so large it needs to be physically separated on the storage array.
  • CamelCasing, the capitalization of each word with no spaces or underscores. CamelCasing will help streamline your work in SSAS.
  • Begin your table with Dim. This allows for better sorting of dimension and fact tables.
  • Don’t over index. Until you know what queries you’ll be running against the tables, don’t assume you need indexes on all the columns.
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

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

%d bloggers like this: