Vendor Dimension

View previous topic View next topic Go down

Vendor Dimension

Post  BIDW on Wed May 27, 2015 7:05 am

Guys I have a Vendor Dimension. The Business has a requirement to include the Category of the Vendor. For E.G. A single Vendor could be supplying Printing Equipment as well as Software. Basically one Vendor could be part of multiple categories. How do you handle such a situation. Do you modify the grain of the dimension table. I am not sure if thats a good idea. Thanks.

BIDW

Posts : 25
Join date : 2015-01-18

View user profile

Back to top Go down

Re: Vendor Dimension

Post  ngalemmo on Thu May 28, 2015 1:08 am

Make category its own dimension and build a vendor/category bridge table. It is a classic multivalued dimension.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Vendor Dimension

Post  BIDW on Thu May 28, 2015 1:37 am

Thank You!

That solves my problem.

BIDW

Posts : 25
Join date : 2015-01-18

View user profile

Back to top Go down

Re: Vendor Dimension

Post  BIDW on Thu May 28, 2015 2:27 am

Thanks. Since I am doing the bridge design for the first time I need more guidance. I understand that Vendor Category is a straight forward dimension but I am not sure how to create the bridge table. I have seen some examples where the bridge table has a group key. A little guidance in slightly more detail is highly appreciated.

BIDW

Posts : 25
Join date : 2015-01-18

View user profile

Back to top Go down

Re: Vendor Dimension

Post  ngalemmo on Thu May 28, 2015 9:51 am

I would not use a group key in this case. Just vendor key and category key should be sufficient. You consider groups if the population of the bridge is unbounded (such as diagnosis related to a doctor visit fact table) and size is an issue. In this case it is bound by the number of vendors. It is also an easier bridge to build.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Vendor Dimension

Post  BIDW on Sat May 30, 2015 11:35 pm

Thank You!! You are absolutely right the number of Vendors is finite, data would grow but not that much. In a Health Care setting there could be several combinations of diagnosis for each patient and it becomes difficult to predict. Thanks for this insight. You Guys are doing a great job.

BIDW

Posts : 25
Join date : 2015-01-18

View user profile

Back to top Go down

Re: Vendor Dimension

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum