You can use a single object as a target for a data transfer task. Select a target object or create a new target object at run time.
The task operations that you can select depend on the target connection that you use. For more information about task operations for different target types, see the help for the appropriate connector.
You can preview the data in the target. The preview returns the first 10 rows. You can download the preview results to a CSV file. To preview rows in alphabetical order, select Display fields in alphabetical order. Data Integration does not change the order of rows in the actual target.
Database target truncation
You can configure a data transfer task to truncate a database target table before writing new data to the table when the task uses an Insert operation. By default, Data Integration inserts new rows without truncating the target table.
Update columns
Update columns are columns that uniquely identify rows in the target table. Add update columns when the database target table does not contain a primary key and the data transfer task uses an update, upsert, or delete operation.
When you run the data transfer task, the task uses the field mapping to match rows in the source to the database table. If the data transfer task matches a source row to multiple target rows, it performs the specified task operation on all matched target rows.