SQL Data Check Action

The SQL Check Action object can be used to check data queries in the database, to ensure that data integrity and ensure that results are returned as expected.

Specifies which variables will be set once action execution is completed

Example

SQL Data Check uses SQL scripts to check data in the database. For example, the user may write the following SQL:

Select count(*) from table

Execution will be successful if the value of the first field of lookup query is more than 0 Execution will fail if the value of the first field of lookup query is equals to 0 or less than 0 or field type is not numeric.

• Advanced ETL Processor Professional and Enterprise Documentation
• Visual Importer ETL Professional and Enterprise Documentation