Home » Developer & Programmer » Designer » Data Modelling (Oracle 11G Unix)
Data Modelling [message #609488] Fri, 07 March 2014 06:36 Go to previous message
Messages: 103
Registered: July 2007
Location: bangalore
Senior Member

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?
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: How to open ER Diagram
Next Topic: Database Design
Goto Forum:

Current Time: Wed Jan 29 14:38:02 CST 2020