Priya Chandrasekhar

Late binding on foreign keys, how strict should staging be?

Staging layer currently rejects any row with a foreign key that doesn't yet exist in the referenced dimension, like an order referencing a not-yet-loaded customer. Load order dependencies are becoming a real headache. Is strict referential enforcement at staging the right call?