Below is a list of Number Validation Functions supported by Advanced ETL Processor
| Image | Data Validation Function | Description |
![]() |
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















