|
tPostgresqlBulkExec
|
Improves performance while carrying out the Insert operations to a Postgresql
database. |
|
tPostgresqlClose
|
Closes the transaction committed in the connected Postgresql database. |
|
tPostgresqlCommit
|
Commits in one go a global transaction, using a unique connection, instead of doing
that on every row or every batch and thus improves performance. |
|
tPostgresqlConnection
|
Opens a connection to the specified database that can then be reused in the subsequent subJob or subJobs.
|
|
tPostgresqlInput
|
Executes a DB query with a strictly defined order which must correspond to the
schema definition. Then it passes on the field list to the next component via a Main row
link. |
|
tPostgresqlInvalidRows
|
Extracts DB rows that do not match a given data quality pattern, you can then
implement any required correction. |
|
tPostgresqlOutput
|
Executes the action defined on the table and/or on the data contained in the table,
based on the flow incoming from the preceding component in the job. |
|
tPostgresqlOutputBulk
|
Prepares the file to be used as parameters in the INSERT query to
feed the Postgresql database. |
|
tPostgresqlOutputBulkExec
|
Improves performance during Insert operations to a Postgresql database. |
|
tPostgresqlRollback
|
Avoids to commit part of a transaction involuntarily. |
|
tPostgresqlRow
|
Acts on the actual DB structure or on the data (although without handling data),
depending on the nature of the query and the database. The SQLBuilder tool helps you
write easily your SQL statements. |
|
tPostgresqlValidRows
|
Extracts DB rows that match a given data quality pattern. |
