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.

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.

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL forum

24/06/2015 18:46 · kevin
  • vimpe/packages/sql_data_check_action.txt
  • Last modified: 26/06/2015 10:35
  • by admin