lamp.
ResourcesPricingAbout

Data mapping

Data mapping is the exercise of matching each field in a source system to the right field in a target system, with any conversion rule needed.

What it means

It is the plan for moving or syncing data. A mapping sheet states that "Cust Name" in the old billing tool becomes "Party name" in the new one, that "Qty" in nos converts to the target unit, and that blank state codes must be filled. It exposes gaps early, such as a field the new system has no place for.

Example

A trading firm in Surat moves from an old billing tool to a new accounting system. The mapping sheet shows the old tool stored GST number inside the address field, so the team writes a rule to split it into a separate field before loading 3,200 parties.

Records and checks

  • Record source field, target field, conversion rule and an example.
  • Verify the mapping on a small sample and compare results to source.
  • The business owner and the technical lead both sign the sheet.

Common mistakes

  • Mapping only field names and ignoring units, formats and codes.
  • Skipping a test load and discovering errors after go-live.
Did not find your answer?Message the lamp team on WhatsApp. Ask about setup, your records, or anything we have not covered here.Ask us on WhatsApp →