Source Mappings for a File Source Type

Source mappings can be added to a file-based integration when you need to add source period mappings between the file-based source system and a target application.

Image show the Source Mapping page.

To create a source mapping for a file source type:

  1. From the Data Integration home page, and then Actions, select Period Mapping.

  2. Select the Source Mapping tab.

  3. From the Source Type, select File.

  4. In Source, select the name of the file.

  5. From Calendar, select the name of the source period mapping calendar.

  6. Click Image shows the Add icon..

  7. From Source Period, enter the file-based source period date value.

    For example, you might select Jan-20.

    Note:

    Period names cannot include spaces if used in a batch script.

  8. In Source Period Year, specify the year associated with the file-based source period date value.
  9. In Source Period Number, enter the number of the period within the fiscal year.

  10. In Target Period Key, enter the last day of the month for the current fiscal year to map to the target system.

    You can select another Target Period Key by clicking Image shows the Search icon. and selecting the period key from the the Search and Select: Period Key page.

  11. The Target Period Name is automatically populated by when the Target Period Key is selected.

    You can select another target period name by clicking Image shows the Search icon. and selecting another (Target) Period Key from the The Search and Select: Period Key page. This page lists all the global mapping periods that are not used in the source mappings for the source.

  12. In Description, enter a description of the period mapping.

  13. Click Save.