Joining 2 Fact Tables from different Sources Before Dimensional Modelling

[AbuHaneefah]

Hi All,

I have a requirement where I have a fact table that is coming through an ETL process that has all the Day -1 data and another similar fact table that just hold current day data that is being held in a materialized view.

I need to present these to the user as a single table. The differences between the table (other than what I have described above) is that the materialized view will not have skeys to join to the dimensions but will have bkeys.

Can anyone give me some guidance on best practices on how to join the 2 facts together and present them as a single Query Subject in Report Studio.
If the filter is Current Day, the Materialized View should provide the data and if the Filter needs any other data it should come from the table.

I hope the requirement is clear, has anyone done anything similar before?

Regards

AH