When a mapping includes a Lookup transformation, the
mapping
task queries the lookup object based on the fields and properties that you configure in the Lookup transformation. The
mapping
task runs a default lookup query when the first row of data enters the Lookup transformation. If the Lookup transformation performs a relational lookup, you can override the default query.
You can override the default query for both cached and uncached lookups. To view the default query, run the