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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.