Destination components

DB Data Sink Insert

Adds records to a database table. You can exclude attributes or assign default values to determine the records you insert into the table.

Use this component to add all records from the IN-port of the component to a database table.

DB Data Sink Update

Updates or overwrites all records that match a selected key. This component does not insert new records.

Use this component to update existing records, not insert new records.

DB Data Sink Delete

DB Data Sink Delete removes records from the destination table that match the incoming values of a selected key. If there are no matching records, DB Data Sink Delete does not display an error message.

Use this component to delete records from the destination table.

DB Data Sink Synchronize

Updates or inserts records based on a selected key attributes values.

DB Data Sink Merge

Uses key attribute values to update and insert records in a destination table.

Text Data Sink

Writes transformation results to a text file in a delimited or fixed-length format.

XML Data Sink

Generates XML output from a data stream and writes the results to the local file system.

DB Bulk Load Sybase IQ

Uses the Load Table utility to add records to a Sybase IQ table.

Use this component to add all records from the IN-port of the component to a table in a Sybase IQ database.