Number of rows to commit
Informatica is processing via a batch job on a 1 Terabyte database.
The deletes are in a 260 gb tablespace (sum of data+ index tablespace) and the inserts are on a 300 gb tablespaces (sum of data + index tablespace).
The undo tablespace is 54 gb with undo_retention of 36000.
The Informatica employees told me that there is a parameter in Power center (informatica) that controls the commits and that the default is 10,000 rows. They ask me to provide a number of rows in which the commits can be performed. This I don't know.
The undo tablespace is 54 gb with undo_retention of 36000.
The Informatica employees told me that there is a parameter in Power center (informatica) that controls the commits and that the default is 10,000 rows. They ask me to provide a number of rows in which the commits can be performed. This I don't know.
0