Transaction control in DataStage can happen in two ways:
1. By Time 2. By Number of Records
We can set environment variable to set the threshold time so that while performing DMLs is process reaches this time it should commit the transaction. Similarly transaction control can be achieved by specifying the number of records in the environment variable so that if DML process the specified number of records then DataStage should commit the transaction.
Transaction control in DataStage can happen in two ways:
ReplyDelete1. By Time
2. By Number of Records
We can set environment variable to set the threshold time so that while performing DMLs is process reaches this time it should commit the transaction. Similarly transaction control can be achieved by specifying the number of records in the environment variable so that if DML process the specified number of records then DataStage should commit the transaction.
Above explained variables are as follows:
APT_ORAUPSERT_COMMIT_ROW_INTERVAL
APT_ORAUPSERT_COMMIT_TIME_INTERVAL
If both are defined then DataStage will take effect of the one which satisfies first.