Back to catalog
Data Engineering

Survivorship Rules & Record Merging

Build a survivorship rule library and produce an auditable Golden Record template that records winning-value logic, provenance and confidence scores for handoff to ERP, EAM or procurement systems.

How this course differsWhat happens after a match: deciding which value wins when duplicate records are merged.

Designed by Isak Marais, Founder & CEO, AICA Data

2.5 hours
13 lessons
intermediate

Free to join. Start straight away.

What you will be able to do
  • Apply attribute-type survivorship patterns to at least three duplicate record examples and execute a merge that produces a tracked Golden Record.
  • Configure precedence and confidence-weight settings in the AICA platform to reflect stated business priorities and data-quality indicators.
  • Analyze conflicting attribute values across duplicate clusters and justify the selected winning value using provenance records, confidence metrics and UNSPSC/GPC codes.
  • Create a formal survivorship rule library and an audit-trail template suitable for handoff to ERP/EAM teams, including rule metadata and rollback steps.
  • Evaluate merged output against ISO 8000 requirements and operational KPIs, identify at least two corrective actions when thresholds fail, and estimate their impact on duplicate rate or item availability.

Part of the Golden Record Architect path

What this course proves

Completing every lesson and passing each module knowledge check at 75% first-attempt accuracy issues a verifiable AICA credential with a unique ID.

Module 1
AICA platform configuration checklist and governance reference mapped to UNSPSC/ISO 8000.
Module 2
A survivorship rule library and an auditable Golden Record template produced during the capstone lab.

Your credential

Proof designed to travel with you

A verifiable certificate, LinkedIn share card and square badge, issued when you complete the course and pass its assessments.

Sample preview

Sample β€” yours will carry your name and unique credential ID.

Achievement levels

Pass

75–84%

Distinction

85–94%

High Distinction

95–100%

Result levels use 70% first-attempt mastery + 30% corrected completion. You must also meet the course’s 75% first-attempt pass requirement; a projected result is not an award.

Explore all credential levels

Who designed this course

IM

Isak Marais

Founder & CEO, AICA Data

Isak Marais is the founder and CEO of AICA Data, and a recognised authority on product, material and spares data. He advises boards and C-suite leaders on AI strategy, enterprise data platforms and digital transformation, and has led AI-driven product data cleansing, enrichment and governance programmes in operational use across 55 countries. He designed and authored the AICA Academy curriculum.

Product data cleansing
Data enrichment
Data governance
UNSPSC classification
Enterprise data platforms
AI strategy
  • CEO of the Year Awards 2024 β€” CEO Monthly
  • Founder & CEO, AICA Data
View LinkedIn profile

Curriculum designed and authored by Isak Marais, developed with AI assistance and reviewed against Quality Matters and OLC OSCQR standards.

Learner reviews

No published reviews yet.

Course Curriculum
1

Survivorship Principles, Governance & AICA Setup

7 lessons β€’ Foundations

1 hour

2

Rule Authoring, Lab Merge & Operationalization

5 lessons β€’ Implementation

1.5 hours

Summative Assessment

Survivorship Rules & Record Merging Capstone Project

Final Assessmentβ€’60 min

Free to join. Start straight away.

Duration2.5 hours
Lessons13
Levelintermediate
Shape the Academy

Help us improve this course

Report an issue or suggest an improvement β€” every idea is reviewed.

Shape the Academy

Spotted something? Have an idea?

Your feedback shapes every course. Report an issue, suggest an improvement, or request a new topic β€” the team reviews every submission.

Β© AICA β€” licensed for enrolled learner use only; redistribution prohibited.