NOTE! This site uses cookies and similar technologies.

If you not change browser settings, you agree to it. Learn more

I understand

Validating Numbers

Below is a list of Number Validation Functions supported by Advanced ETL Processor

ImageData Validation FunctionDescription
Is Number Checks if the data is a Number
Is Integer Checks if the data is an Integer
Is Positive Checks if the data is a Positive Number
Is Negative Checks if the data is a Negative Number
Is Number Between Checks if the data is a number between two values
Is Number Less Than Checks if the data is a number less than value
Is Number More Than Checks if the data is a number more than value


Advanced ETL Processor is designed to automate extracting data from ANY database, transform, validate it and load into ANY database . Typical usage of it would be extract data from Excel File,Validate Date Formats, Sort data, deduplicate it and load it into Oracle database, run stored procedure or Sql script, once loading is completed. Unlike Oracle SQL loader, BCP,  DTS or SSIS Advanced ETL Processor can also add new and update old records based on primary key

Visit Support Forum Learn More Download Buy It

One of the good things about Advanced ETL Processor that the trial has no limitations. There is no need to fill in any registration forms or to buy the software in advance.  That saved us a lot of time and we were able to load and  validate all our data when we needed it urgently.

John Parker.

Our customers

BP

BBC

HSBC

Orange

CAT

SEPA
emc
NHS
Australian Rugby Union
xerox
Databases we work with