Confirm that foreign keys resolve across tables and surface orphan records, late-arriving dimensions, and broken joins.
