Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have two fact tables and 5 dimension tables. Fact tables should not be linked. What is the better approach to design the data model?
As of now, I have designed by joining the dimension tales to fact tables. But in the application, I have charts from both fact tables and filters from dimension tables. Now the problem is I have to pass the dimension filed selections to respective fields to both the fact tables since the fact tables are connected, could anyone guide me on this?
Regards,
Shruthi
Hi Shruthi,
As per My thought process you need to add link table.
For more detail please provide sample data in excel .
Thanks & Regards,
Arvind Patil