7.3.3 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 FTP Lookup Data Loader.
7. Select the Insertion Mode from the options Delete and Insert or Append. For more details, see Define a Task.
8. Enter the remaining parameters and for Data File Name, create a data file (.CSV) with the file name INPUT_YYYYMMDD_FTP_LOOKUP_<DATA FILE NAME>.CSV. For example, INPUT_20150315_FTP_LOOKUP_Data1.CSV.
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.