DSXchange

Yes Ray, I made Array Size as 100 and Transaction Size as 30000( to avoid more numbr of commis to be done). Now I have gained performance.i.e the job is taking 12 mins of time now. For this job J1 to complete, it took 18 Minutes. The no.of records selected is 1, 63, 497 . Still I believe it can be t...

I Changed my buffer size from 128 KB to 256 KB and timeout from 10 sec to 100 sec.

The job worked without the error mentioned. Thanks Ray, and what made you to think on these lines (i.e on Buffer size and Timeout)

Ray, Interproces communication was enabled. Then the same error was coming. Then I enabled In process communication. Then also the same error occurred. Yes, I do have two adjacent active stages in design. Transformers are connected adjacently. I have Source stages(Oracle) S1, 5 transformers (T1, T2,...

But I do get DSR.ADMIN: Failed to enumerate local groups.

Is this an issue

In Admin, already server side tracing was disabled

I got this error Abnormal termination of stage CopyOfStgOrderCommWeekly300307..Tr_On_Off detected When it is reset From previous run DataStage Job 1124 Phantom 13418 Program "DSR_PROJECT": Line 695, Available memory exceeded. Unable to continue processing record. Abnormal termination of Da...

I checked . The time taken for the second job is 11 mins. I feel this is also big time. The array size is 32767. When the job started rows/sec was 600. When number of records read from sequential file was around 31000, trwos /sec gradually reduce to 300. Thereafter it continued with 300 rows/sec. I ...

Is it that you want me to fisrst select records from D1.T1 and store them into sequnetial file and then load the sequential records into D2.T2.

If so instead of modifying J1,I can modify job J2, by adding o/p link from sequential file to D2.T2.

Is this ok to check your option.

I am selecting records from table T1 of Database D1 and inserting them into table T2 OF Database D2. For this job J1 to complete, it took 18 Minutes. The no.of records selected is 1, 63, 497. So, i thought the performance is poor. Then I developed JOb j2 where I am selecting records from table T1 of...

Yes,

Sorry that I could not grab the issue in Scale. I changed my datatype in database from NUMBER to NUMBER(38,12). Now I am getting the required output.

I have a small doubt . even NUMBER should accept Decimal digits right?

Ray, The datatype in Datastage is decimal whose lenght is 38 , display is 40, no value for scale. There are no errors or warnings in logs. Chulett, Yes, Chullet even when I multiplied with +1 it is giving a value of 0. Only when it is directly mapped, I am getting original values. This is wierd. Wha...

The datatype in database is number. In Transformer it is decimal, lenght =38, display=40

I tried using -A. Still the output value is 0.

I have a i/p link variable A in transformer and I doing a derivation as A*-1. (i.e i need to negate the vaue of A) When value of A is 0.00999, A*-1 is giving result as 0. Whereas only A is giving , it is giving 0.00999. Why am I getting a value of 0 when it is multipled by -1. Any solution for this.

Thanks for your solutions. My logic is working now with your solutions