Study guide
6.4 Reference Data Governance & Standards
DAMA Certified Data Management Professional CDMP
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: Exam Overview & DMBoK Framework
1.1 CDMP Exam Details & Strategy 1.2 The DMBoK Framework 1.3 Data Management Organization & Roles
2 Chapter 2: Data Governance (Part A)
2.1 Data Governance Principles & Drivers 2.2 Operating Models & Structures 2.3 Policies, Standards, and Procedures
3 Chapter 2: Data Governance (Part B)
2.4 Data Stewardship 2.5 Governance Metrics & Implementation
4 Chapter 3: Data Modeling and Design (Part A)
Section 3.1: Conceptual, Logical, and Physical Models Section 3.2: ERD Notations & Relational Modeling Section 3.3: Normalization
5 Chapter 3: Data Modeling and Design (Part B)
3.4 Dimensional Modeling 3.5 Naming Standards & Modeling Best Practices
6 Chapter 4: Data Quality (Part A)
Section 4.1: Data Quality Dimensions Section 4.2: Data Quality Policy & Rules Section 4.3: DMAIC & DQ Improvement Lifecycle
7 Chapter 4: Data Quality (Part B)
4.4 Root-Cause Analysis & Remediation 4.5 DQ Metrics, Tools, and Reporting
8 Chapter 5: Metadata Management (Part A)
5.1 Business, Technical, and Operational Metadata 5.2 Metadata Lineage & Impact Analysis 5.3 Repository Architectures
9 Chapter 5: Metadata Management (Part B)
5.4 Standards and Semantics 5.5 Metadata Governance & Integration
10 Chapter 6: Master and Reference Data Management
6.1 Master vs Reference Data 6.2 MDM Repository Architectures 6.3 Match-Merge & Identity Resolution 6.4 Reference Data Governance & Standards
11 Chapter 7: Data Warehousing and Business Intelligence
7.1 DW Architectures: Inmon vs Kimball 7.2 Data Warehousing Storage & Load Patterns 7.3 BI Delivery & OLAP 7.4 Data Marts & Enterprise Data Warehouses
12 Chapter 8: Data Architecture
8.1 Enterprise Data Architecture & Zachman Framework 8.2 Data Flow Diagrams & Value Chains 8.3 Architecture Frameworks & Standards
13 Chapter 9: Document and Content Management
9.1 Records Management & ECM 9.2 Retention, Disposal, and E-Discovery 9.3 ARMA GARP Principles & Taxonomies
14 Chapter 10: Data Integration and Interoperability
Section 10.1: Integration Patterns & Technologies Section 10.2: Replication & Virtualization Section 10.3: Canonical Models & Integration Standards
15 Chapter 11: Data Security
Section 11.1: Security Principles: CIA Triad & Privacy Section 11.2: Access Control & Encryption Section 11.3: Security Regulations & Standards
16 Chapter 12: Data Storage and Operations
Section 12.1: Database Technologies & DBA Roles Section 12.2: Backup, Recovery, and High Availability Section 12.3: Performance Tuning & Operations
17 Chapter 13: Big Data and Data Science
13.1 Big Data V's & Technologies
18 Chapter 14: Data Ethics
14.1 DMBoK Data Ethics Framework
19 Chapter 15: Data Management Process and Maturity
15.1 Maturity Assessment Frameworks
6.4 Reference Data Governance & Standards
Key Takeaways Explain This Topic AI
International standards for reference data include ISO 3166 (countries), ISO 4217 (currencies), ISO 5218 (sexes), and ISO 639 (languages).
Reference codes should never be hard deleted from databases; instead, a soft delete using effective dates or active flags prevents breaking historical referential integrity.
Cross-walk tables are required to map and translate disparate local systems' codes to standardized enterprise reference values.
Reference data changes require formal stewardship evaluation because they modify structural database constraints and downstream reporting lines.
Last updated: July 2026
Reference Data Governance and Standards
Reference data provides the classifications, code lists, and lookup values that establish context across systems. Although reference data typically has a much smaller footprint than master data, its impact is enterprise-wide. A single incorrect code or an unmapped reference table can halt transaction flows, corrupt financial dashboards, or lead to regulatory compliance failures. Therefore, Reference Data Governance and adherence to international standards are critical disciplines within the DAMA framework.
Global and Industry Reference Data Standards
To promote interoperability and simplify integration, organizations should adopt international standards for common reference data domains. The CDMP exam heavily tests familiarity with standard ISO codes and industry classifications:
1. ISO 3166 (Country Codes)
This standard defines codes for the names of countries, dependencies, and special areas of geographical interest:
ISO 3166-1 Alpha-2 : Two-letter codes (e.g., US for United States, CA for Canada, GB for United Kingdom). This is widely used for internet top-level domains.
ISO 3166-1 Alpha-3 : Three-letter codes (e.g., USA , CAN , GBR ), which are more readable and help avoid ambiguity.
ISO 3166-1 Numeric : Three-digit codes (e.g., 840 for United States, 124 for Canada, 826 for United Kingdom). These are useful in systems that do not support Latin alphabets.
2. ISO 4217 (Currency Codes)
This standard defines three-letter codes for currencies (e.g., USD for US Dollar, EUR for Euro, JPY for Japanese Yen). The first two letters represent the ISO 3166 country code, and the third letter represents the currency name (e.g., US + D for Dollar).
3. ISO 5218 (Representation of Human Sexes)
This standard defines representation codes for human sexes:
- 0 = Not known
- 1 = Male
- 2 = Female
- 9 = Not applicable
- 4. ISO 639 (Language Codes)
This standard classifies languages using two-letter (ISO 639-1) or three-letter (ISO 639-2/3) codes (e.g., en or eng for English, es or spa for Spanish).
5. Industry-Specific Reference Codes
NAICS and SIC : Used by government and businesses to classify industry establishments based on the primary economic activity (e.g., manufacturing, retail, services).
ICD-10/ICD-11 : International Classification of Diseases, maintained by the World Health Organization (WHO), used globally for medical diagnostics and billing.
UNSPSC : Universal Standard Products and Services Classification, a hierarchical framework used for classifying products and services in procurement and spend analysis.
Reference Data Governance Lifecycle
Reference data requires formal governance policies to manage changes. Unlike transactional data, reference data changes are structural and affect database constraints, integration pipelines, and historical reporting.
Change Management and Approval
Any request to add, modify, or retire a reference code must go through a formal change request process. The request is evaluated by data stewards to assess the downstream impact. For instance, if an organization decides to retire an old product category code, the stewards must identify all active products using that code and map them to the new category before the change is approved.
The Principle of Soft Deletes
A core rule of reference data management is that codes should never be deleted from the database. If a code is deleted, historical transactions referencing that code will violate referential integrity constraints, leading to database errors or orphaned records. Instead, reference tables must implement a soft delete pattern. This involves using metadata attributes such as IsActive (Boolean flag) or EffectiveStartDate and EffectiveEndDate columns. When a code is retired, its EffectiveEndDate is set to the current date, and IsActive is set to false. This prevents new transactions from using the code while preserving historical records for reporting.
Mapping and Translation (Cross-walks)
In heterogeneous IT landscapes, different systems often use different codes to represent the same concept. For example, System A might use M and F for gender, System B might use 1 and 2 , and System C might use Male and Female .
To enable data integration and interoperability, organizations build Cross-walk Tables (or mapping tables) that translate local system codes to a standard enterprise reference code or an international standard.
- Local System A Code Local System B Code Enterprise Reference Code ISO 5218 Code Description
- M 1 MALE 1 Male
- F 2 FEMALE 2 Female
- U 0 UNKNOWN 0 Unknown
Managing cross-walks requires active governance. Whenever a source system updates its local codes, the mapping tables must be updated in tandem to prevent integration failures.
Reference Data Distribution Architectures
To ensure consistency across the enterprise, reference data should be managed centrally in a Reference Data Management (RDM) system and distributed to subscribing applications. The two primary distribution patterns are:
Push Architecture : The central RDM system pushes reference data updates to downstream applications via database replication, file transfer, or enterprise service buses. This ensures that downstream applications have local copies of reference tables, minimizing read latency.
Pull Architecture : Consuming applications query the central RDM system in real-time via REST APIs or web services whenever they need to validate a code or display a dropdown list. This guarantees that systems always use the most up-to-date codes, though it introduces a network dependency.
DAMA Exam Traps and Study Tips
ISO Standards Memory : You must memorize the specific ISO standard numbers. The exam frequently asks which standard defines country codes (ISO 3166), currency codes (ISO 4217), representation of human sexes (ISO 5218), and language codes (ISO 639).
Deleting Reference Data : Watch out for questions asking how to handle retired reference codes. The correct answer is always to retire the code using start/end dates or status flags, never to perform a hard delete.
Ownership of Reference Data : Reference data is not owned by IT. Business data stewards and governance committees own the definitions and mappings, while IT is responsible for the distribution and technical implementation.