Customer Dim, Vendor Dim, or combined?

jpayton at 04h33
09
May
2009
Customer Dim, Vendor Dim, or combined?

Hi All,

Just considering a design approach for a new project. The situation will quite frequently exist where a Customer is also a Vendor, and we will need to look at a summarized 'account'. So the question is, should we create separate customer and vendor dimensions, or a single table that is an Account? The dimension tables will not in fact be too large, so I'm not worried about having slow performance; more of the the issue is e
About
This topic belongs to the forum
  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
I am trying to model a Customer Dimension with Educational and Employment details and I want some advice on how to model this scenario A Customer can have several levels of Education like schooling, college, university, training (one to many realtionship
Hello, I'm working definining a dimensional model in a bank. We have Teradata as DB and MicroStrategy as BI tool. We have many fact tables and most of the fact table lowest level is the "Contract" dimension. We have many other dimensions that
I have a question regarding de-normalizing customer data to create a single customer dimension! Let's say our OLTP customer information is made up of 2 tables. 1) Customer Table (customer name, customer type, etc...) 2) Address Table (address1,
I have a requirement to start capturing addresses in our data warehouse for detailed analysis of customer returns. Up until now, analysis at postal code has been sufficient. The company I work is mail order, so the addresses I need to record
As part of an Orders dimensional model, I am attempting to design the Customer Dimension table. The customers have multiple sold-to addresses and multiple ship-to addresses. While the OLTP allows any Order to have any combination of sold-to and ship-to
Forums from same category
See also
more_less
Informations

6 Replies For the topic :
"Customer Dim, Vendor Dim, or combined?"

This topic has been viewed 1000 times.

Last message :
09/05/2009 at 04h33 by "jpayton"