Below is a list of Miscellaneous Transformations supported by Advanced ETL Processor
Image | Data Transformation Function | Description |
---|---|---|
Date Format | Returns Date in ‘yyyy-mm-dd hh:nn:ss.fff' format. In order to load Date fields into target database, they should be converted into ‘yyyy-mm-dd hh:nn:ss.fff' format | |
Current Date | Returns Current Date in ‘yyyy-mm-dd hh:nn:ss.fff' format | |
Length | Returns Length of String | |
Literal | Populates field with a constant value | |
User | Returns Current Windows User Name | |
Get Excel Cell Value | Returns Cell value of an Excel file | |
Get File Content | Returns content of a single file | |
Splitter | Splits data into a number of values using Delimiter and Qualifier | |
Joiner | Joins several values into one value delimited Delimiter and surrounded by Qualifier if specified | |
Accumulate Strings | Accumulate strings data transformation function adds strings from previous records together, | |
Case | Conditional Mapping | |
URL Location | Use URL location transformation to determine location parameters of URL such as Country, City, Region, Post Code, Street, latitude and longitude | |
IP Location | Use IP location transformation to determine location parameters of IP address such as Country, City, Region, Post Code, Street, latitude and longitude | |
URL shortener |
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, de-duplicate 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 the primary key