3.6.6 Importing Data using Scheduler Service

To import the Lookup Table Data using Scheduler Service:

1. Navigate to Scheduler Service, select Define Batch.
2. Click Create from Actions.
3. Create a batch and save it.
4. Navigate to Scheduler Service, select Define Task.
5. Create a Task.
6. Select the Component as Lookup Table Data Loader.
7. In the Task Parameter section, select the following values:

   Table 3-27 Lookup Table Parameters

   Parameter	Description
   Folder	Select the folder used to filter and locate the Lookup Table rule.
   Lookup Table Rule	Select the Lookup Table rule to execute or process.
   File Name	Input name of file, containing lookup data, without prefix and extension. Example ‘DATA1 Note: Actual name of file that must be uploaded to object store will be INPUT_YYYYMMDD_PBSM_LOOKUP_<file_name>.csv, example INPUT_20150315_PBSM_LOOKUP_DATA1.csv. Here YYYYMMDD is the As of Date for which data is being loaded or Batch MIS Date."

8. Select the Insertion Mode from the options Delete and Insert or Append. For more details, see Define a Task.
9. Execute the task. Select the As of Date as the date that is used in the CSV file name.
10. Monitor the task. For more details, see Monitor Batch.
11. Navigate to the Lookup Table summary screen and verify the imported Lookup Table definition.