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
 

Testimonials

Advanced ETL Processor's ability to validate and tranform data without actually loading it into the datawarehouse has saved us a lot of time. We were able to see how data will look like, once it is transformed and which records would fail during data validation.

Antony Clark,
RBS 
 

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.ABIP.abipformdeditor.jpg
DB Software Laboratory - Intel Software PartnerDB Software Laboratory - My SQL Ready Partner
DB Software Laboratory Embacadero Technology Partner