Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Dimensional modeling of product and vendor for invoice fact

2 posters

Go down

Dimensional modeling of product and vendor for invoice fact Empty Dimensional modeling of product and vendor for invoice fact

Post  kjfischer Wed Jun 08, 2011 2:51 pm

On the source system, the invoice_detail table carries the both the part_id and the vendor_id (for that part) on it.

The source system part table carries the vendor that supplies that part. A part has only one vendor.

Is there any value to having two dimensions, part_dim and vendor_dim to join to the invoice_detail fact table?

kjfischer

Posts : 28
Join date : 2011-05-04

Back to top Go down

Dimensional modeling of product and vendor for invoice fact Empty Re: Dimensional modeling of product and vendor for invoice fact

Post  ngalemmo Wed Jun 08, 2011 3:18 pm

You are far better off with two dimensions. Each dimension table will be smaller and perform better. Plus you can implement the relationships (per your other post) between vendor and employees. If it was one dimension, you would need to relate employess to parts... probably not a desireable thing to do.

It also gives you greater flexibility should the business processes change... such a sourcing the same part from multiple vendors.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Back to top

- Similar topics

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