tVerticaCommit
that on every row or every batch and thus provides gain in performance.
tVerticaCommit Standard properties
These properties are used to configure tVerticaCommit running in
the Standard Job framework.
The Standard
tVerticaCommit component belongs to the Databases family.
The component in this framework is available in all Talend
products.
connector. The properties related to database settings vary depending on your database
type selection. For more information about dynamic database connectors, see Dynamic database components.
Basic settings
Database |
Select a type of database from the list and click |
Component List |
Select the component in which the relevant reused connection is configured. |
Close Connection |
Select this check box to close the database connection once the component has performed Clear this check box to continue to use the selected connection once the component has If this component is linked to your Job via a Row > Main connection, your data will be committed row by row. In this case, do not |
Advanced settings
tStatCatcher Statistics |
Select this check box to gather the Job processing metadata at the Job level |
Usage
Usage rule |
This component is more commonly used with other tVertica* Talend Studio and the |
Dynamic settings |
Click the [+] button to add a row in the table Once a dynamic parameter is defined, the Component List box in the Basic For examples on using dynamic parameters, see Reading data from databases through context-based dynamic connections and Reading data from different MySQL databases using dynamically loaded connection parameters. For more information on Dynamic |
Related scenario
For tVerticaCommit related scenario, see Inserting data in mother/daughter tables