Database Connection Parameters
You can create user-defined database connection session parameters to reuse sessions for different relational sources, targets, or lookups. You can create a database connection parameter in the session properties of any session that uses a relational source, target, or lookup. Name all database connection session parameters with the prefix $DBConnection, followed by any alphanumeric and underscore characters. When you define the parameter in the parameter file, you can reference any database connection in the repository.
For example, you have a session you want to use with two relational sources. You access the first source with a database connection named “Marketing” and the second with a connection named “Sales.” In the session, you create a source database connection parameter named $DBConnection_Source. In the parameter file, you define $DBConnection_Source as Marketing and run the session. After the session completes, dyou set $DBConnection_Source to Sales in the parameter file, and then run the session.
Alternatively, you can create two different parameter files, one for each source database connection. You can then use pmcmd to specify which parameter file to use when you start the session.
If you want to use the same database connection for more than one connection, such as source and target, you can enter the same $DBConnection parameter for both source and target database connection. In the parameter file, enter one default value for the $DBConnection parameter. The PowerCenter Server uses the same DBConnectionName when accessing source and target.Similarly heterogeneous sources may also use the same $DBConnection parameter.