This tutorial shows dynamic lookup in Advanced ETL Processor. Use it when a transformation needs to find related values during processing instead of relying on fixed, hard-coded mappings.
What You Will Learn
- Understand where dynamic lookup fits in a transformation.
- Match incoming data against lookup data.
- Use lookup results in downstream transformation logic.
- Avoid hard-coded values when the reference data changes.
Before You Start
Prepare the source data and the lookup data first. A lookup without reference data is just a very confident blank stare.
Related Transformation Tutorial
For a broader lookup example, see Perform ETL data transformations using the lookup object.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.