Combining night-market ticket scans with a many-row vendor catalog on a loose key multiplies rows and fabricates extra purchases. How should the team combine those sources?
Select an answer to reveal the explanation.
Short Explanation
Think of ticket scans joined to a many-row vendor catalog on a loose key, and suddenly extra purchases appear. Aggregate first, or join on a well-keyed relationship. A loose-key explosion fabricates sales.
Full Explanation
Combine related sources without unintended row multiplication. Aggregate then join, or use a well-keyed join. A loose-key explosion, a spreadsheet paste, and Polly fabricate extra purchases.