ERP Data Cleansing & Migration Strategy 2 — Questions and Answers
Question 1: Which data profiling technique identifies the percentage of records with missing values in a field?
- Referential integrity check
- Completeness analysis (Correct answer)
- Duplicate detection
- Format validation
Correct answer: Completeness analysis
Completeness analysis measures what proportion of records have populated values for each field.
Question 2: During ERP migration, a 'delta load' refers to:
- Migrating only deleted records
- Migrating only records changed since the last extract (Correct answer)
- Migrating the entire dataset in one pass
- Migrating data from legacy to staging only
Correct answer: Migrating only records changed since the last extract
A delta load captures and migrates only the records that have been added or modified since the previous data extraction.
Question 3: What is the primary purpose of a data steward during an ERP migration project?
- Writing ETL transformation scripts
- Owning accountability for data quality within a business domain (Correct answer)
- Managing database server infrastructure
- Approving project budgets
Correct answer: Owning accountability for data quality within a business domain
A data steward is a business-side role responsible for defining data rules, resolving quality issues, and ensuring domain data is fit for purpose.
Question 4: Which approach best reduces cutover risk when migrating a high-volume ERP general ledger?
- Single big-bang migration of all history on go-live weekend
- Migrating only open balances and archiving history separately (Correct answer)
- Skipping GL migration and re-entering all transactions manually
- Delaying GL migration until six months post go-live
Correct answer: Migrating only open balances and archiving history separately
Migrating open balances and archiving historical GL data reduces cutover window duration while preserving compliance access.
Question 5: A 'freeze period' in ERP migration is best described as:
- A time when all data cleansing activity stops
- A window where source system transactions are halted to create a stable migration snapshot (Correct answer)
- A period when the project team cannot make scope changes
- A database backup retention policy
Correct answer: A window where source system transactions are halted to create a stable migration snapshot
A freeze period halts or minimizes source system activity so that the extracted dataset is stable and consistent for final migration.
Question 6: Master data deduplication during ERP migration most commonly uses which technique to identify potential matches?
- Full outer join on primary keys
- Fuzzy matching algorithms on name and address fields (Correct answer)
- Checksum comparison of entire records
- Random sampling of 10% of records
Correct answer: Fuzzy matching algorithms on name and address fields
Fuzzy matching detects near-duplicate records where names or addresses differ slightly due to abbreviations, typos, or formatting inconsistencies.
Question 7: In the context of ERP data migration, 'data harmonization' means:
- Deleting all records that do not conform to new standards
- Standardizing data from multiple source systems into a unified format and taxonomy (Correct answer)
- Backing up all source data before migration begins
- Synchronizing ERP with third-party payment gateways
Correct answer: Standardizing data from multiple source systems into a unified format and taxonomy
Harmonization resolves differences in codes, units, and naming conventions across disparate source systems so all data conforms to a single target model.
ERP Data Cleansing & Migration Strategy 2
Which data profiling technique identifies the percentage of records with missing values in a field?