|
tDBBulkExec
|
Offers gains in performance while executing the Insert operations on a
database. |
|
tDBCDC
|
Extracts only the changes made to the source operational data and makes them
available to the target system(s) using database CDC views. |
|
tDBCDCOutput
|
Synchronizes data changes in database of the selected database type in the CDC
mode. |
|
tDBClose
|
Closes the transaction committed in a connected database. |
|
tDBColumnList
|
Iterates on all columns of a given database table and lists column
names. |
|
tDBCommit
|
Validates the data processed through the Job into the connected
database. |
|
tDBConnection
|
Opens a connection to a database to be reused in the subsequent subJob or
subJobs. |
|
tDBInput
|
Extracts data from a database. |
|
tDBInvalidRows
|
Checks database rows against specific Data Quality patterns (regular expression)
or Data Quality rules (business rule). |
|
tDBLastInsertId
|
Obtains the primary key value of the record that was last inserted in a database
table by a user. |
|
tDBOutput
|
Writes, updates, makes changes or suppresses entries in a database. |
|
tDBOutputBulk
|
Writes a file with columns based on the defined delimiter and the standards of
the selected database type. |
|
tDBOutputBulkExec
|
Executes the Insert action in a database. |
|
tDBRollback
|
Cancels the transaction commit in a connected database to avoid committing part
of a transaction involuntarily. |
|
tDBRow
|
Executes the stated SQL query onto a database. |
|
tDBSCD
|
Reflects and tracks changes in a dedicated database SCD table. |
|
tDBSCDELT
|
Reflects and tracks changes in a dedicated SCD table through SQL
queries. |
|
tDBSP
|
Calls a database stored procedure. |
|
tDBTableList
|
Lists the names of specified database tables using a SELECT statement based on a
WHERE clause. |
|
tDBValidRows
|
Checks database rows against Data Quality patterns (regular
expression). |
|
tParseRecordSet
|
Parses a recordset rather than individual records from a table. |
