This deprecated node deletes designated rows from an existing database.
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.
Properties
Table
Specify the name of the database table to remove data from.
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 YYYY-MM-DD.
DateColumn
Optionally specify a date field to check if either TODAY or an actual date is given for CleanResults.
Script
Optionally specify an expression controlling how to output data.
CommitFrequency
Optionally specify how many rows to process before committing changes to the database.
SqlDateType
Optionally specify the datatype in which to map a SQL DATE. Choose from:
- date
- datetime
Inputs and outputs
Inputs: None.
Outputs: Multiple optional.