Instructor-Led Courses
EDI Fundamentals
&
Best Practices
March 13-14, 2012  Chicago, IL
April 17-18, 2012  Dallas, TX
May 15-16, 2012  New York, NY
June 14-15, 2012  San Diego, CA
July 05-06, 2012  London, UK
July 10-11, 2012  San Diego, CA
August 07-08, 2012  Dallas, TX
September 11-12, 2012  Boston, MA
October 02-03, 2012  Chicago, IL
November 13-14, 2012  Dallas, TX
December 04-05, 2012  New York, NY
January 15-16, 2013  San Diego, CA
January 24-25, 2013  Seattle, WA
Become Certified by
The EDI Academy
Register Now

The following is an extract from the mapping session of the EDI Training Course:

Mapping Best Practices

The following mapping best practices can be applied to most EDI applications.
Identifying and Understanding the Data

The mapping work should start long before opening the mapper feature of the EDI application. The mapper should have a business analyst role of gathering data requirements. During the process of gathering requirements, the input data format and the output data format must be identified and understood by the mapper. The content of the data and the format of the data have to make sense to the mapper. If the mapper feels that the input or the output format of the data is unreasonable (e.g. too much unnecessary data) then the mapper should make the case for this concern and not simply map away with unreasonable data formats. This will help prevent troubleshooting and maintaining the map in the future and should make the data conversion process more efficient.

While Mapping
  • Connect elements/segments at the same hierarchal level. For example, connect header level segments on the input side to the header level segments on the output side, detail to detail, and summary to summary.
  • Connect elements/segments with the same data type. For example, map the numeric fields to numeric fields, date to date, string to string. Make the data type in both the input and output section the same when possible.
  • Set the same maximum usage (loops) on the input and output side of the map.
  • Create all segments/elements in the map that will be in the file. For example, if in the CSV file a certain column is not being used, map it anyway. Some translators require all the fields be mapped and this is a good practice for troubleshooting.
  • Use standards when possible (ASC X12, EDIFCAT, RosettaNet and etc)
EDI Academy © 2007 - 2012. All Rights Reserved.
Home | EDI Course Information | EDI Course Schedule | Testimonials | About The EDI Academy | Careers | Forum