Dimensional modeling of product and vendor for invoice fact

View previous topic View next topic Go down

Dimensional modeling of product and vendor for invoice fact

Post  kjfischer on 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

View user profile

Back to top Go down

Re: Dimensional modeling of product and vendor for invoice fact

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

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