Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Seperate Customer Dimension
Thanks for your reply, after looking at the data, I found that Customer to contract relation is one to many. In this case, my approach is that, I have ContractMaster Dimension and ContractDetail dimension tables right now. Since for each contract we would like to see the individual information...- Narasig
- Post #6
- Forum: Data Warehousing/Big Data
-
Seperate Customer Dimension
Thanks for your reply contract to customer is at most one. Furthermore, is a Contract able to be moved from one Customer to another? -- this is not moved. Is a Contract able to be attributed to more than one Customer or to just one? . Its one customer only. In this scenario, can we...- Narasig
- Post #3
- Forum: Data Warehousing/Big Data
-
Seperate Customer Dimension
Hi I am working for insurance client, they had already Contract Dimension called as Policy Dimension. The contract Id (PK) is referenced in Customer Dimension.SInce there is need for more attributes in contract dimension from EDW stand point of view, we have to design a new dimension Contract...- Narasig
- Thread
- Replies: 6
- Forum: Data Warehousing/Big Data
