I’m curious how this is handled in real life, beyond diagrams and “best practices”.
In your organization, how do you manage reference data like:
- country codes
- currencies
- time zones
- phone formats
- legal entity identifiers
- industry classifications
Concretely:
- Where does this data live? ERP, CRM, BI, data warehouse, spreadsheets?
- Who owns it, IT, data team, business, no one?
- How do updates happen, manually, scripts, vendors, never?
- What usually breaks when it’s wrong or outdated?
I’m especially interested in:
- what feels annoying but accepted
- what creates hidden work or recurring friction
- what you’ve tried that didn’t really work
Not looking for textbook answers, just how it actually works in your org.
If you’re willing to share, even roughly, it would help a lot.
submitted by /u/anasharn
[link] [comments]
