Indexed table output
The Indexed Table Output step allows you to load data into a database table. Table Output is equivalent to the DML operator INSERT. This step provides configuration options for target table and a lot of housekeeping and/or performance-related options such as Commit Size and Use batch update for inserts.
An index with selected “Key fields” will be created when the last record are finished loaded into the target table.
Options
Section titled “Options”The table below describes the available options for the Table output step:
| 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 write data to. This is important for data sources that allow for table names with periods in them. |
| Target table | The name of the table to which data is written. |
| Commit size | Use transactions to insert rows in the database table. Commit the connection every N rows if N is larger than zero (0) |
| Field that contains name of table | When the option “Is the name of the table defined in a field?” is enabled, enter the field name to use here. |
| SQL | Generates the SQL to create the output table automatically |