Question 300
A transformation merges order data from two sources with identical columns in different positions. What should the acceptance test demonstrate?
Explanation
Correct Answer
This directly verifies the intended outcome: Name-aware union avoids positional column corruption. The accepted result is: All records retain correct business fields regardless of source column order.
Incorrect Answers
Required fields disappear.
Cartesian multiplication duplicates records.
Customer id can enter amount column.