Database Reference
In-Depth Information
Lookup Sql Override
, as indicated in the following screenshot, is a property that is avail-
able if you are using lookup transformation to look up a table. When you use lookup
transformation to look up a table, it generates a default query to extract the data from the
table and bring in Informatica PowerCenter. You can modify the default query generated
by the lookup transformation, which is referred to as a lookup SQL override. Using this
property, you can save time by eliminating unwanted records while extracting itself.
If you use lookup transformation to look up a file, you will need to define
Look-
upFileDirectory
and
LookupFileName
, as shown in the following screenshot: