Hi,
We are using Mercator6.7 version and Iam trying to improve the performance in Loading data into oracle(9i) database.
To load large volume of data mercator is taking more time compared to DataStage.
I tried with so many scenarios like workspace and pagesize and pagecount but I didnot get better performance compared to DataStage.
Can anyone help me in this regard how to make settings in the command line of the outputcard to have BULKLOAD OCI into oralce.
Thankyou in advance
We are using Mercator6.7 version and Iam trying to improve the performance in Loading data into oracle(9i) database.
To load large volume of data mercator is taking more time compared to DataStage.
I tried with so many scenarios like workspace and pagesize and pagecount but I didnot get better performance compared to DataStage.
Can anyone help me in this regard how to make settings in the command line of the outputcard to have BULKLOAD OCI into oralce.
Thankyou in advance