Question 330
A finance dimension has two versions with the same business key but a fact join expects exactly one match. Which test result satisfies the scenario?
Explanation
Correct Answer
This directly verifies the intended outcome: Overlapping SCD windows create ambiguous joins and inflated measures. The accepted result is: Each fact row maps to one appropriate dimension version without multiplication.
Incorrect Answers
Correct historical attributes may disappear.
Fact rows duplicate.
Historical joins become ambiguous.