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?
|
|
|
|
Re: Data Modelling [message #609497 is a reply to message #609494] |
Fri, 07 March 2014 11:03 |
nagaraju.ch
Messages: 103 Registered: July 2007 Location: bangalore
|
Senior Member |
|
|
AS i mentioned there may be customer from multiple sources, Eg: customer1 from Facebook and Twitter. In that case Primary key doesn't work right?
|
|
|
|
Re: Data Modelling [message #642325 is a reply to message #609498] |
Tue, 08 September 2015 02:44 |
|
nettechindia09
Messages: 3 Registered: August 2015
|
Junior Member |
|
|
Data modeling techniques and tools capture and translate complex system designs into easily understood representations of the data flows and processes,
|
|
|