Destination Components

Destination components (also called data sinks) write data to specific targets. This component type has one input port and no output port.

• Preconditions for Using DB Data Sink Components for Bulk Loading
  You must enter the Load Stage Path for the DB Data Sink components to support IQ bulk loading. To support IQ bulk loading with client-side loading, the DB Data Sink components must meet some conditions.
• DB Bulk Load Sybase IQ
  DB Bulk Load Sybase IQ is a destination component that performs bulk operation on a Sybase IQ table.
• DB Data Sink Delete
  DB Data Sink Delete removes records from a database 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.
• DB Data Sink Insert
  DB Data Sink Insert adds records from the IN-port to a database table. You can exclude attributes or assign default values to determine the records you insert into the table.
• DB Data Sink Update
  DB Data Sink Update component updates or overwrites all records that match a selected key. This component does not insert new records. If there are no matching records, DB Data Sink Update does not display an error message.
• Text Data Sink
  Text Data Sink is a Destination component that writes transformation results to a text file in a delimited or fixed-length format.