...
Option | Description |
---|---|
Step name | Name of the step; this name has to be unique in a single transformation. |
Connection | The database connection to which data is written |
Target schema | The name of the Schema for the table to which data is written. This is important for data sources that allow for table names with periods in them. |
Target table | Name of the table in which you want to do the insert or update. |
Commit size | The number of rows to change (insert / update) before running a commit. |
Don't perform any updates | If enabled, the values in the database are never updated;only inserts are performed. |
Key Lookup table | Allows you to specify a list of field values and comparators. You can use the following comparators: =, <>= ~NULL, <>, <, <=, >, >=, LIKE, BETWEEN, IS NULL, IS NOT NULL
|
Update Fields | Allows you to specify all fields in the table you want to insert/update including the keys. Avoid updates on certain fields by specifying N in the update column.
|
SQL button | Click SQL to generate the SQL to create the table and indexes for correct operation. |
...