JDBC Connector
>
Mappings and mapping tasks with JDBC
> JDBC lookups in mappings
JDBC lookups in mappings
In a mapping, you can configure a Lookup transformation to represent a JDBC object. When you use a JDBC object as a lookup, you do not need to configure specific JDBC properties.
You can't configure a Lookup transformation in a data transfer task.