Use the following rules and guidelines when you create a mapping with a Transaction Control transformation:
If the mapping includes an XML target, and you choose to append or create a new document on commit, the input groups must receive data from the same transaction control point. |
Transaction Control transformations connected to any target other than relational, XML, or dynamic MQSeries targets are ineffective for those targets. |
You must connect each target instance to a Transaction Control transformation. |
You can connect multiple targets to a single Transaction Control transformation. |
You can connect only one effective Transaction Control transformation to a target. |
You cannot place a Transaction Control transformation in a pipeline branch that starts with a Sequence Generator transformation. |
If you use a dynamic Lookup transformation and a Transaction Control transformation in the same mapping, a rolled-back transaction might result in unsynchronized target data. |
No comments:
Post a Comment