Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Conformed Dimensions

Conformed Dimensions

Conformed Dimensions

Hi All,

I am new to Dimensional modelling and wanted to know in basic terms, what is a conformed dimension?

Many Thanks

RE: Conformed Dimensions

two seconds on google, and here are the first two results --

Dimensions are conformed when they are either exactly the same (including keys) or one is a perfect subset of the other.
-- http://en.wikipedia.org/wiki/Dimension_(data_warehouse)

A conformed dimension is a set of data attributes that have been physically implemented in multiple database tables using the same structure, attributes, domain values, definitions and concepts in each implementation.
-- http://data-warehouses.net/glossary/conformeddimensions.html

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

RE: Conformed Dimensions

This is the part that confuses me....if one dimension is exactly the same as the other dimension then why have two dimensions the same?

Or am I missing something very obvious here?


RE: Conformed Dimensions

I use the definition found here when referring to a conformed dimension:


A simple answer is that a conformed dimension is a dimension that is shared across fact tables.

You don't need to have multiple tables, you simply need to have a dimension that works the same way within your data warehouse.  So for example, your Location dimension would be designed so that it may support both your Sales data mart as well as your GL data mart.  You would need multiple physical dimensions if your data marts were physically separated, or if you have declared a view for a role-playing dimension based off of your core dimension.  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close