Multi Fact and Dimension

[Anonymous]

Hello

How you handle the situation when you faced multi fact and dimensions in data model?

please explain in detail..

Thank you.

[its_anandrjs]

Hi,

If you have multiple fact table in the data model then create link tables between two fact tables and connect them.Connect this fact table with composite keys between them.

Regards,
Anand