DSXchange

Hi,
I need to process one row at a time. I mean my job needs to touch 2nd row after 1st row got processed completely. I am pulling data from oracle and doing some transformations and then passing to java integration stage. So I need to process one row at a time because java integration stage writes output values to a table and I need to consider those table values before the system process next row. Please advise me how can I achieve this?

Thank you,

The easiest way is to use a Server Job....it does that by default, provided you haven't played around with the process row buffering settings at the Project level....and if you are doing things in real-time, it's not likely that you'll need much parallelism anyway.

Ernie

I was going to suggest that but felt it might be too sacrilegious for this forum. And wasn't sure if it supported the Java Integration stage.

Thanks Ernie,
I was using parallelism all the time but for this particular job I need to consider the output of previous processed rows to process remaining rows thats why I run in to this issue. I will check process row buffering settings at project level also. Thanks for your input.

Ernie,
Server job doesn't support java integration stage. Any suggestions please?

Thank you,

Use server job components loaded into a server Shared Container which you can (if the rules aren't violated) use in a parallel job. The rules are in Chapter 2 of the Parallel Job Developer's Guide.

The Java Integration Stage is an "upgraded" version of the former JavaClient and JavaTransformer Stages. Better API, more features and more performant.

But the older ones are still there. Just look for them in the Server Stage folder in the repository.

They use an older but very similar API (which is also supported in the new Stage). Lots of threads and examples are around. You should very easily be able to adapt your class to the older stages.

Ernie

Thanks Ernie