When you use dynamic MQSeries target definitions in a mapping, the PowerCenter Integration Service can maintain transactional consistency when writing data to message queues. When the PowerCenter Integration Service maintains transactional consistency, it commits messages to the target after it writes all messages in a transaction group to the target. A transaction group consists of all messages that the PowerCenter Integration Service commits when it reaches a commit point. If a session aborts or fails during a transaction, the PowerCenter Integration Service rolls back all messages in the transaction group from the target.

When you enable recovery and a session aborts or fails, you can restart the session in recovery mode. In a recovery session, the PowerCenter Integration Service writes the messages to the message queues. This is because the PowerCenter Integration Service could not successfully commit all messages in the group to the targets. It can then process the messages to the targets in the next session.

To ensure transactional consistency, all dynamic MQSeries target definitions in the same pipeline must belong to the same target connection group. MQSeries target definitions that are in the same target connection group receive data from the same transactional source. Additionally, two or more dynamic MQSeries targets are in the same target connection group if they have the same value for the Queue Manager property.