Step Three: Create the Field Mapping File
In this step, you create a mapping file with an .sdl
file extension. In each line of the mapping file, pair a data source with its destination.
Copy the following to a text file and save it with a name of
accountInsertMap.sdl. This code is a data insert, so the data
source is on the left of the equals sign and the destination field is on the right.
1#Mapping values
2 #Thu May 26 16:19:33 GMT 2011
3 Name=Name
4 NumberOfEmployees=NumberOfEmployees
5 Industry=IndustryFor complex mappings, you can use the Data Loader user interface to map source and destination fields and then save those mappings to an .sdl file. It’s done on the Mapping dialog box by clicking Save Mapping.