Deletes designated rows from an existing database table and then loads in new data.
A property with one of the following values ALL, TODAY, NONE, or a date of the form CCYY-MM-DD, specifies which data to remove before loading.
Properties
Table
Specify the name of the database table into which the input data is loaded.
A value is required for this property.
DbUser
Specify the database username to connect to the database.
A value is required for this property.
DbPassword
Specify the database user's password to connect to the database. This password is stored as clear text in the data flow and sent via clear text to the Data360 Analyze server. Therefore, it's important either to put this password into a data flow-level property or to use a user with limited privileges.
A value is required for this property.
DbService
Specify the database instance name, for example:
CustomerInfo
A value is required for this property.
DbInterface
Specify the type of interface. Choose from:
- oci - Oracle.
- cli - Teradata.
- odbc - MS Access and SQL Server.
A value is required for this property.
CleanResults
Optionally specify criteria to determine what data to remove from the table before loading:
- ALL - Remove all rows
- TODAY - Remove rows committed today (based on a date field in the table)
- NONE - Don't remove any rows
Alternatively you can enter a data in the format CCYY-MM-DD.
DateColumn
Specify a date field to check if either TODAY or an actual date is given for CleanResults.
DbLoadExprs
Optionally specify expressions to determine what data from the input is loaded into the database.
Example: Loads all input data into the table
emit *
AbortThreshold
Optionally specify the number of errors to encounter before aborting.
Leave empty to continue through any errors encountered.
MissingColumnBehavior
Optionally specify the behavior if a value is not set for a database column:
- Ignore - Errors are ignored.
- Log - Errors are logged but the node does not fail.
- Error - Errors will cause the node to fail.
The default value is Error.
ExtraFieldBehavior
Optionally specify the behavior if the output contains a field not present in the database table:
- Ignore - Errors are ignored.
- Log - Errors are logged but the node does not fail.
- Error - Errors will cause the node to fail.
The default value is Log.
Inputs and outputs
Inputs: in1.
Outputs: ErroredData, 1 optional.