Synthetic key due to date field

[Anonymous]

Can anyone please explain to me how to get rid of the synthetic key, but still keeping both fact tables linked to the master calendar table (without having to use a date island if possible.

[Anonymous]

Hi Chantelle,

Rename the sl_no in both tables.

eg: for Ledger_Data table, you can have sl_no as Ledger_Data_sl_no