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

Dimensional Model Question

Dimensional Model Question

Dimensional Model Question

Has anyone ever faced a problem where the data in a column of the source system table breaks down into multiple dimensions in the star schema?

I am working through the design of a data mart based on our Ordering System.  The 'destination'column of each order can be a customer id, a route number, or a location number.  The attributes of each of these are completely different, and I would not want to combine them into one dimension.  

Would the fact table have separate columns for each each type of destination?  If so, what happens if we add a new destination type?

I have also thought about snow flaking the  destination dimension, putting the destination type, and the foreign key of each destination in the first dimension. Secondary dimension tables with destination specific attributes would be then be added for each type of destination.   

I read an article on Kimball's website that talked about hot swapping dimensions, but I couldn't really understand how to implement it.  

Any thoughts?

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