User`s guide

CHAPTER 6 Components
User’s Guide 111
Use this component if you want to add all records from the IN-port of the
component to a database table.
❖ To use DB Data Sink Insert
1 Add the component to the project and connect the ports to adjacent
components.
2 Enter the Connection Parameters as described in “Entering database
connection parameters” on page 71.
3 Create a destination table. If the destination table you are going to use
already exists, continue with step 5.
4 Right-click the component and select either Add Destination Table from
Input, or Add Destination Table from Port. Optionally, the command lets
you create the destination table based on the IN-port structure of the
component or the structure of any other port within the project. However,
you might also create the destination table with your own toolset.
5 Click Destination Table, and select the table to be used from the list of
available tables.
Optional properties
Insert Options
Click Insert Options to open the Insert Options window. By default, all
attributes will be inserted. Deselect the attributes you want to exclude from
insertion. This is useful if, for example, an attribute is automatically defaulted
by the database system. You may specify a
SQL INSERT value clause for each
attribute, overwriting the incoming value of the selected attribute.
An example of the
SQL INSERT value clause is:
'valid'
'[uDate("now")]'
Truncate Table
Activate this option to remove all records from the destination table when
initializing the transformation process.
Write Block Size
The Write Block Size defines the number of records to be written to the
database in a single write operation.