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.
my question is that we have to reference Customer details like (first name ,lastname and so on ) from the contract.
Do we have to reference customer key in Contract Dimension or any other ways to get the customer details from contract.
if any one has implemented like this, what are the advantages and issues pls. let me know.
Thanks in advance,
Narasimha
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.
my question is that we have to reference Customer details like (first name ,lastname and so on ) from the contract.
Do we have to reference customer key in Contract Dimension or any other ways to get the customer details from contract.
if any one has implemented like this, what are the advantages and issues pls. let me know.
Thanks in advance,
Narasimha