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?