DB Clean Loader - Data360_Analyze - 3 - 3.12

Data360 Analyze Server Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 Analyze
Version
3.12
Language
English
Product name
Data360 Analyze
Title
Data360 Analyze Server Help
Copyright
2023
First publish date
2016

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.