Update SQL Query

[chulett]

Then it should be working fine... right?

[pkomalla]

Try to divide the updates and inserts in the transformer itself. Use Oracle stages two one for update and one for insert if you have inserts.

In transformer write constraints saying if ename=",.." and dept=.. then go to update stage or insert stage.

[sb_akarmarkar]

Then it should be working fine... right? ...

Question is still there how to pass old DEPT and new DEPT to Update table where we have only one target table DEPT as in tarnsformer while mapping...

Thnaks,
Anupam

[sb_akarmarkar]

Now problem is solved i passed value of old dept to DEPT and new dept to dummy DEPT and modified update statement...

Thanks all,

Anupam