Close





Lost Password?
No account yet? Register
Increase font size Default font size Decrease font size Narrow screen resolution Wide screen resolution Auto adjust screen size default color red color blue color yellow color orange color

Number Transformations

Below is list of Number Transformations supported by Advanced ETL Processor

Round Rounding is the process of reducing the number of significant digits in a number. The result of rounding is a "shorter" number having fewer non-zero digits yet similar in magnitude. The result is less precise but easier to use.For example: 73 rounded to the nearest ten is 70, because 73 is closer to 70 than to 80.
Abs Returns absolute value of a number. Absolute value is always positive. For example -2 will give 2
Sign Returns Sign of numeric value -1 for negative values, 1 for positive values and 0 for 0

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
 

Testimonials

My boss told me to keep looking for a more expensive application, assuming Visual Importer ETL couldn't be very good because the price was just too low.  After testing several imports I convinced him that Visual Importer did everything we want so there was no need to pay for a more expensive solution.

Ron Bradshaw,
IT Reporting Manager,
ConAgra Foods / Lamb Weston
 

Free Newsletter

Please provide your Name and Email address so that we can tell you about latest releases, new features and free offers.






b.150.100.16777215.0..Screenshots.AdvancedETL.aetl7.jpg
DB Software Laboratory - Intel Software PartnerDB Software Laboratory - My SQL Ready Partner
DB Software Laboratory Embacadero Technology Partner