Performance tuning in datastage

[mtechnocrat1]

Hi
I want to do performance tuning in Datastage.My row count/sec is very low....I want to increase my ROW COUNT / Sec.....

How to do this ....????

Thanks in Advace....

 

[mchafry]

Hi,

To tune Datastage performance, you have to diagnostic two sides :

* Database side, see your DBA
and
* Datastage side : So you can use a DS debugger or Tracing option to see when the system take a lot of time, in reading or writing, etc. You can copy-paste all the result in the DS Director to the Excel spreadsheet and DO more analyze

Mostafa

Mostafa Chafry
Advisor Oracle and Business Intelligence
********************************
MCIA Solution Inc.

http://www.MCIAsolution.com