You cannot use unconnected lookups for mappings in advanced mode.

You cannot configure a dynamic lookup cache for mappings in advanced mode.

A Lookup transformation with the

On Multiple Matches

property configured as

Report Error

, runs successfully without displaying an error message for mappings in advanced mode.

You cannot use the SQL query property for uncached lookups.

To use the IS NULL and IS NOT NULL operators in an uncached lookup, you need to set the -DENABLE_NULL_FLAG_FOR_UNCACHED_LOOKUP=true property as a JVM option under the DTM type in the Secure Agent properties. You can use only the = and != operators. The task fails if you use any other operator.