SQL Lookup

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

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

Video Tutorial

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: 03/10/2018 14:42
  • by admin