Mapping

Ask review

Map source schemas and systems to target, define transformation rules

Hats
2
Review
Ask
Unit Types
Mapping
Inputs
Assessment

Dependencies

Assessmentmigration-inventory

Hat Sequence

1

Compatibility Reviewer

Focus: Review the schema-mapper's spec for correctness, completeness, and feasibility. Flag type mismatches that lose data, semantic gaps where source and target concepts diverge, and constraint conflicts that will cause runtime failures. Ensure downstream consumers are not broken by the mapping decisions.

Produces: Compatibility review with flagged issues, resolution recommendations, and sign-off on the mapping spec.

Reads: Mapping specification from the schema-mapper, target system constraints, downstream consumer contracts.

Anti-patterns:

  • Rubber-stamping the mapping without verifying type compatibility
  • Focusing only on structural compatibility and ignoring semantic differences
  • Approving lossy transformations without documenting the data loss implications
  • Ignoring the impact on downstream consumers that read from the target
  • Reviewing in isolation without referencing the risk register from assessment
2

Schema Mapper

Focus: Produce field-level mappings from every source entity to its target equivalent. Define explicit transformation rules — renames, type casts, derivations, default fills, and drops. Document what changes and why, so migration scripts can be generated deterministically from the spec.

Produces: Mapping specification with source-to-target field mappings, transformation rules, and edge-case handling decisions.

Reads: Migration inventory, source and target schema definitions, data dictionaries.

Anti-patterns:

  • Mapping only the happy path and ignoring nulls, encoding, or precision differences
  • Leaving fields as "TBD" instead of making an explicit decision (even if that decision is "drop")
  • Assuming field names that match across systems have identical semantics
  • Creating mappings that can't be tested in isolation
  • Ignoring constraints (unique, foreign key, check) that differ between source and target

Mapping

Criteria Guidance

Good criteria examples:

  • "Every source field maps to a target field with explicit transformation rules (rename, cast, derive, drop)"
  • "Incompatible types are listed with chosen resolution strategy and data loss implications"
  • "Edge cases document at least: nulls, encoding differences, precision loss, and constraint violations"

Bad criteria examples:

  • "Mapping is done"
  • "Schemas are compared"
  • "Transformations are defined"

Completion Signal

Mapping document exists with field-level source-to-target mappings for every entity. Transformation rules are explicit and testable. Compatibility review has flagged all type mismatches, constraint differences, and semantic gaps with resolution decisions documented.