SQL Lookup
SQL Lookup is the slowest transformation. It is used only when nothing else is working.
| Key | Value |
|---|---|
| Category | Transformation Function |
| Description | This function retrieves values from the database using SQL. Parameters are replaced with actual values before the execution. |
| Properties |
Parameters
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