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
Miscellaneous Transformations

Below is list of Miscellaneous Transformations supported by Advanced ETL Processor

Date Format Returns Date in ‘yyyy-mm-dd hh:nn:ss.zzz' format.In order to load Date fields into target database they should be converted into ‘yyyy-mm-dd hh:nn:ss.zzz' format
Current Date Returns Current Date in ‘yyyy-mm-dd hh:nn:ss.zzz' format
Length Returns Length of String
Literal Populates field with a constant value
User Returns Current Windows User Name
Splitter Splits data into number of values using Delimiter and Qualifier
Joiner Joins several values into one value delimited Delimiter and surrounded by Qualifier if specified

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
 

Main Menu

Home
News
Links
Press Releases
FAQs
Contact Us
Awards
Search

Order Now