New data transformation function creates copies (clones) of a row and outputs them directly after the original row to the next steps.
Clone row properties Dialog
In new release of Advanced ETL Processor data sorting functionality is improoved by allowing the user to define directory to store temorary files and specify memory buffer dedicated to sorting
Sorting is the process of arranging data into meaningful order so that you can analyze it more effectively. For example, you might want to order sales data by calendar month so that you can produce shop performance report.
New version Database Browser is available for download. In this version we have introduced data import wizard.
This easy to use tool allows user to connect to any database and browse or modify data,run sql scripts, export and print data. And the most important thing it is Free-ware.
New release of Advanced ETL Processor adds Range Lookup function our vast library of data transformation functions.
Performing range lookups (or to finding a key for a given range) is a common ETL operation in data warehousing scenarios. It's especially for historical loads and late arriving fact situations, where you're using type 2 dimensions and you need to locate the key which represents the dimension value for a given point in time.
Data for lookup can be entered manually or loaded from the database or a file