DB Truncate - 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

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.

CAUTION:
This node has been deprecated and will not be supported in a future release. As an alternative, the DB Execute node can be used to provide similar functionality.

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.