Using the File Mapping Definition

Use the File Mapping Definition component to map and define a data file to be converted to target staging tables. The key element in a File Mapping definition is the context definition to be referenced. After you identify the context definition, identify the external data file layout. The external fields are then mapped to the available target records and fields.

Use the File Definition tab to identify the context definition and general attributes of the data file to be processed. Use the External Award Load context definition for external files that contain data that you want to convert and update the external award staging tables. If your external file has multiple row types, then only identify the row types that have data that you want to convert.

Use the File Layout tab to identify the external file fields and format.

Use the Mapping tab to define how the target staging table and fields are updated when the external file is processed. For example, your external file probably contains a field comparable to the required SFA_EA_REPORT_CD field on the staging table record SFA_EASTAGE_DTL. On the Mapping tab for this field, set the Mapping Action field to Default Value and enter A=Append, R=Replace, or N=New. When the external file is processed, the SFA_EA_REPORT_CD field is then populated with that value.