Database Reference
In-Depth Information
Lookup queries
Similar to the Source Qualifier transformation, which generates a default query when you
use the source as a relational database table, the Lookup transformation also generates a de-
fault query based on the ports used in the Lookup transformation. To check the default
query generated by the Lookup transformation, click on the
Properties
tab and open
Look-
up Sql Override
, as shown in the following screenshot:
Similar to overriding the default SQL in the Source Qualifier transformation, you can over-
ride the default query generated by the Lookup transformation. If you override the default
query generated by the Lookup transformation, it is referred to as a lookup SQL override.