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

a

ImageData Validation FunctionDescription
Is Time Checks if the data is a time value
Is Time Between Checks if the data is a time between two values
Is Time Less Than Checks if the data is a time less than the value
Is Time More Than Checks if the data is a time more than the value
Is Second Checks if data is a number between 0 and 59
Is Minute Checks if data is a number between 0 and 59
Is Hour 24 Checks if data is a number between 0 and 23
Is Hour 12 Checks if data is a number between 0 and 12
Is PM Checks if the data is a PM Date
Is AM Checks if the data is an AM Date

 

Advanced ETL Processor has a robust data validation and transformation process built-in.

The types and nature of the transformations taking place can be tweaked and configured by the user. A full range of data transformation functions is included. Transformations can be performed on the basis of data type, lookups and regular expressions, which can be individually changed according to the requirements.

 

More transformation functions