How Do I Use the Data Mapper to Get Negative Numbers from a Flat File Source into a Destination? (Magic xpi 4.7)

When you need to map a flat file with Numeric value that might be a negative number into a Destination, you need to modify the Source properties by adding a Numeric data type field and modifying its format from 12 to N12.