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 also select the Target Period Key by clicking Image shows the Calendar icon. and selecting the period.

  11. In Target Period Name, select the period name of the target period. Enter a description for the mapping.

    You can also select target period information by clicking Image shows the Calendar icon. and selecting the name. The Search and Select: Period Key page is displayed. 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.