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.

Use this component to delete records from the destination table.

Text Data Sink

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

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.