Advanced-etl-processor
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 quotes around ‘<Parameter1>’, use this approach for string parameters
To change Transformation function properties double click on it
Video Tutorial
We have more videos on ETL-Tools.com YouTube Channel,
Please take a look and subscribe to stay updated with the latest content.
Back to Working with Transformer
For more technologies supported by our ETL Software see Advanced ETL Processor Versions
Confused? Ask question on our ETL Forum