SQL Lookup

SQL Lookup is the slowest transformation. It is used only when nothing else is working.
CategoryTransformation Function
DescriptionThis function retrieves values from the database using SQL. Parameters are replaced with actual values before the execution.

Note: <Parameter1> inside SQL box

Note single quote around '<Parameter2>', use this approach for string parameters

To change Transformation function properties double-click on it

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL forum

  • aetle/transformation_functions/lookups/sql_lookup.txt
  • Last modified: 01/08/2022 15:03
  • by admin