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.

To create a source mapping for a file source type:

1. From the Data Integration home page, and then from the Actions menu, then from the Setup actions drop-down, select Period Mapping.

   Note:

   To use an explicit period mapping in a file-based integration, you must include the period dimension on the Map Dimensions tab in the integration definition. The explicit period mapping is defined on the source mapping tab in period mappings. The map dimensions tab is also referred to as the ."import format."

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 .

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 and selecting the period key from 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 and selecting another (Target) Period Key from 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.