Announcement: New Design for docs.informatica.com!
We have updated the look and feel of docs.informatica.com. To load the latest design, press CTRL-F5 to clear the pages you previously cached on our site, or simply restart your browser.
The Integration Service queries the lookup based on the ports and properties you configure in the Lookup transformation. The Integration Service runs a default lookup query when the first row enters the Lookup transformation.
If you use a relational lookup or a pipeline lookup against a relational table, you can override the lookup query.
You can use the override to change the ORDER BY clause, add a WHERE clause, or transform the lookup data before it is cached.
If you configure a SQL override and a filter on the lookup query, the Integration Service ignores the filter.