Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
s
You have a data model with two fact tables (actual and target) and a synthetic key linking them, it looks like. I would put the two tables in a single fact table.
See more on
Fact Table with Mixed Granularity
Concatenate vs Link Table
HIC
.png "Former Employee"){kind=icon}