You can output data to multiple targets in the same session. When the target types or database types of those targets differ from each other, you have a session with heterogeneous targets.
To create a session with heterogeneous targets, you can create a session based on a mapping with heterogeneous targets. Or, you can create a session based on a mapping with homogeneous targets and select different database connections.
A heterogeneous target has one of the following characteristics:
Multiple target types.
You can create a session that writes to both relational and flat file targets.
Multiple target connection types.
You can create a session that writes to a target on an Oracle database and to a target on a DB2 database. Or, you can create a session that writes to multiple targets of the same type, but you specify different target connections for each target in the session.
All database connections you define in the Workflow Manager are unique to the Integration Service, even if you define the same connection information. For example, you define two database connections, Sales1 and Sales2. You define the same user name, password, connect string, code page, and attributes for both Sales1 and Sales2. Even though both Sales1 and Sales2 define the same connection information, the Integration Service treats them as different database connections. When you create a session with two relational targets and specify Sales1 for one target and Sales2 for the other target, you create a session with heterogeneous targets.
You can create a session with heterogeneous targets in one of the following ways:
Create a session based on a mapping with targets of different types or different database types. In the session properties, keep the default target types and database types.
Create a session based on a mapping with the same target types. However, in the session properties, specify different target connections for the different target instances, or override the target type to a different type.
You can specify the following target type overrides in a session:
Relational target to flat file.
Relational target to any other relational database type.
Verify the datatypes used in the target definition are compatible with both databases.
SAP BW target to a flat file target type.
When the Integration Service runs a session with at least one relational target, it performs database transactions per target connection group. For example, it orders the target load for targets in a target connection group when you enable constraint-based loading.