mea0730 at 10h11
15
May
2010
De-normalizing Customer Information to create a Customer Dimension
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, address2, city state, zip, etc...) with multiple addresses per customer.
Obviously I would have repeating customer data for
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, address2, city state, zip, etc...) with multiple addresses per customer.
Obviously I would have repeating customer data for
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
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
Hi,
Does anyone know the best way to model customer age? I guess there are 3 options: 1)Just their birth date, 2)Their current age as an attribute, 3)their age as an attribute but make it a type 2 scd so that you get all their age history.
This is
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
Hi All,
I design customer dimensions, but in our concept we have two types of customer the customer as the owner and the customer as one member in customer group which we call it contract,and some times the contract is the owner One-To-one .
From this
Forums from same category
LEGO Island Discussion, modding, news and more!
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
HmongThoobNtiajTeb. com/
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
Search
Informations
8 Replies For the topic :
"De-normalizing Customer Information to create a Customer Dimension"
This topic has been viewed 2841 times.
Last message :
15/05/2010 at 10h11 by "mea0730"






