How do I configure a data loader task for incremental loading?
Configure the following options:
- On the Connect Source page, under Define Primary Keys, select Automatically detected from source or Enter manually.
The task uses the primary key fields to uniquely identify records. If primary keys are defined, the task can update existing rows when you re-run the task. If they aren't defined, the task can only insert rows.
- On the Connect Source page, under Define Watermark Fields, select Automatically detected from source or Enter manually.
The task uses the watermark fields to determine which records were added or changed since the last task run.
- On the Connect Target page, under Load to existing tables, select Yes.
This option causes the task to load data to the existing target tables instead of creating new target tables each time you run the task.
How do I verify that my data loader task has no configuration errors before I run it?
In the data loader task, click the Validation icon in the upper right corner. The Validation panel opens and displays the message "Task is valid" if there are no configuration errors. If there are errors, they are listed in the validation panel.
How do I find a data loader task that I created earlier?
Click Explore in the navigation menu on the left. On the Explore page, open the project that contains the task. If you're not sure which project contains the task, you can enter the task name or part of the name in the find box.
How do I rename, copy, or move a data loader task?
Click Explore in the navigation menu on the left. On the Explore page, open the project that contains the task. In the row that contains the task, open the Actions menu and select the appropriate option.
On the My Jobs page in Data Loader or the All Jobs page in Monitor, click the job instance name to open the job details. Check the error messages on the job details page.
You can also download a log file by clicking the Download Session Log icon in the row that contains the object that couldn't be loaded.