| Data Modelling [message #609488] |
Fri, 07 March 2014 06:36  |
nagaraju.ch
Messages: 103
Registered: July 2007
Location: bangalore
|
Senior Member |
|
|
Hi,
I have been given a task to create data model for my organisation's Warehouse, I decided to build Start Schema but when i see Customer Dimension, data comes from several sources. Our aim is to deduplicate the customers. and need to keep some of the fields from each source in warehouse dimension table. If you take Social as source, Customer may come through several social sites Facebook, Twitter, Instagram and etc. need to keep track of each social site as well. Geographical detail come from sales source, Loyalty score comes from CRM system. we have e-mail id as Key in all the systems.
My table would be look like below:
Customerid, name, gender,zipcode, Facebook, Twitter,Instagram,Geographical Score, Loyalty Score and etc.]
Can we split this into several tables and reduce the null values?
Can you please advise on this?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
