Orabulk in Parallel

devanars · Post by **devanars** » Tue Jan 13, 2009 11:56 am

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

ray.wurlod · Post by **ray.wurlod** » Tue Jan 13, 2009 3:09 pm

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.