Hi,

I have a request to link my Fact table: i.e

Fact Premium table
-Date_Key
-Customer_Key
-Policy_No
-Premium_Paid
-Outstanding_Amount

I had another table from OLTP in normalized form of i.e Coinsurer File

Policy No
Coinsurer_Name
Coinsurer_Pct

i.e.
Policy No Coins_Name Pct
00001 AAA 20
00001 BBB 50

Request to calculate how much the premium for each coinsurer.

With the above scenario, should I create a new fact for this?

Need advice.

Thanks

regards,
Jw

Hi Jw,

You can join the Fact Premium table with Coinsurer File having Policy
No as common column in both table.

Try this out if this solves the problem.

Sushil