- PowerCenter 10.4.0
- All Products
Use a connection object that you configure for the session. The SQL transformation connects to the database once during a session.
Connect to databases depending on connection information you pass to the transformation in a mapping. When you configure a dynamic connection, choose whether the transformation requires a connection object name or the transformation requires all the connection information. Default is connection object.
Dynamic connection only. Use a LogicalConnectionObject port to receive the connection object name. Define the connection object in the Workflow Manager connections.
Full Connection Information
Dynamic connection only. Use input ports to receive all the connection components.