insert and update into same OCI

[ray.wurlod]

Use Code tags for formatting job designs, it's so much neater.

If you're going to update hashed files in "real time", then you need not only to disable read cache but also to lock for updates and to disable write cache in the other Hashed File stage.

This has been discussed before. Search, perhaps, for "lock for update" exact match.

And, of course, you need to pre-load the hashed file with keys from the target table. It's OK to use write cache to improve performance of this preliminary step.

[ray.wurlod]

The Transformer stage is in the job design posted. You haven't really contributed anything beneficial.

[sumeet]

thanks
I have tried everything with hash file including lock for updates and disbling the cache. I was the one who had posted it. right now performance is not in picture.

Still working on it . any ideas are welcome
Sumeet