Preface
Data integration tasks
Mapping tasks
Data transfer tasks
Data loader tasks

Tasks

Back Next

Dropping and re-creating target tables

You can configure a

data loader

task to drop the target tables and re-create them every time the task runs. When you select this option, the task deletes the target tables created by the original task run and creates new tables using the schema of the source objects.

To configure the task to drop and re-create the target tables, select

No, create new tables every time

under

Load to existing tables

on the

Connect Target

page. To ensure that the task processes all records each time it runs, you also need to select

Watermark field not required

under

Define Watermark Fields

on the

Connect Source

page.

When you select these options, the task performs a full target load each time it runs.

Step 2. Connect to your target

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Tasks

Tasks

Dropping and re-creating target tables

Dropping and re-creating target tables