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

Text Data Sink writes transformation results to a text file in a delimited or fixed-length format.

DB Bulk Load Sybase IQ

DB Bulk Load Sybase IQ performs bulk operation on a Sybase IQ table.

Use this component to manipulate records of a table in a Sybase IQ database based on the records from the IN-port of the component.