DSXchange

Hi

Dont we have orabulk stage in parallel jobs!

Is there any way to capture rejected records by using
write method = sqlloader but not upsert

Thanks

Yes, it's called the Oracle Enterprise stage with load method = "Write". This invokes sqlldr "under the covers".

Once sqlldr is started DataStage no longer has control. You can process the log and bad files produced by sqlldr in DataStage once sqlldr finishes, but there is no mechanism to capture rejected records while sqlldr is running, exactly as there isn't when invoking sqlldr by any other mechanism.