When you configure the source and target instances, you can override connection attributes and define some attributes that are not in the connection object. You can override connection attributes based on how you configure the source or target instances.
You can override connection attributes when you configure the source or target session properties in the following ways:
You use an FTP, queue, external loader, or application connection for a non-relational source or target.
You use an FTP, queue, or external loader connection for a relational target.
You use an application connection for a relational source.
You configure connections in the Connections settings on the Mapping tab.
You can override connection attributes in the session or in the parameter file:
Session.
Select the connection object and override attributes in the session.
Parameter file.
Use a session parameter to define the connection and override connection attributes in the parameter file.