To create a data load rules file:
Determine whether to use the same rules file for data loads and dimension builds.
See Creating Rules Files.
Map each rules file field to the data source and define field properties.
If necessary, set record, field, and data operations to change the data in the data source during loading.
See Using a Rules File to Perform Operations on Records, Fields, and Data.