In this tutorial, you will learn how to use Advanced ETL Processor Pro lookup object to perform data transformation.

The Lookup transformation performs lookups by joining data in input columns with reference table columns. You use the lookup to access additional information in a related table that is based on values in common columns. The reference table can be any supported file type or database. The reference table is loaded into the memory cache before running the transformation

The best way to become acquainted with the new tools, controls and features available in Advanced ETL Processor Pro is to use them.

This tutorial is intended for users familiar with fundamental database operations, but who have limited exposure to the new features available in Advanced ETL Processor Pro

All our ETL Software have no limitations, which means you can load your data today and solve all the data quality problems right now.

Our WIKI has more detailed information if you are stuck post your question on our ETL Support forum and we will do our best to assist you