How to design a customer risk rating model on data warehouse

Hi All,

� 

We are in the process of building a customer risk rating model on existng� data warehouse. Customer's profile data is stored in DimCustomer dimension table.Customer products (e.g. saving account,credit card,loan..)� are stored in DimCustomerProducts Table.

� 

Now we are to calculate customer Risk (=profile risk+product risk)� on the basis of his demographic profile attributes ...