Set -DEnableSingleCommit=true in the Secure Agent properties

Perform the following tasks to set the property for the Secure Agent:

Open Administrator and select
Runtime Environments
.
Select the Secure Agent for which you want to set the property.
On the upper-right corner of the page, click
Edit
.
In the
System Configuration Details
section, select the
Type
as
DTM
for the Data Integration Service.
Edit the JVM options and set the property to
-DEnableSingleCommit=true
.

Set the EnableSingleCommit property in the task properties

After you run a mapping, the results are not displayed in the order of query execution. You can view the queries and the affected rows for each query in the session log.
When you select the data driven target operation and set the
Treat Source Rows As
option to
None
for a target, consider the following guidelines:
When you enter a single value, such as, DD_INSERT, DD_UPDATE, or DD_DELETE in the data driven condition, the target operation specified in the data driven condition is considered and the target operations are processed in a predefined order of delete, update, upsert, and insert.
When you enter a Nested IFF statement or DD_REJECT in the data driven condition, the data driven target operation is considered and the target operations are not processed in a predefined order.
The order of execution of post SQL and pre SQL queries after the -DEnableSingleCommit=true property is set differs from the order of execution before the property was set.