Update only

rafidwh · Post by **rafidwh** » Sun Jul 15, 2007 8:08 pm

Hi All,

My source is a Flat file and target is Oracle stage.

Source Col: src col1;src col2; src col3
Target:Tgt Col1

I need to update TgtCol1 in table which is mapped with src col1 and the condition for the update is src col2=tg2 col2 and src col3=tgt col3.
I am not moving col2 and col3 .

Please suggest me how write the query and also how to set the property for update only in Oracle stage.

Please through some light,
Regards,
Rafidwh

ray.wurlod · Post by **ray.wurlod** » Sun Jul 15, 2007 10:24 pm

First YOU shed some light.

Is this the Oracle Enterprise stage, or one of the other Oracle stages? Your answer affects the advice that we need to give.

rafidwh · Post by **rafidwh** » Mon Jul 16, 2007 12:07 am

Ray sorry to confuse it is other oracle stages

ray.wurlod · Post by **ray.wurlod** » Mon Jul 16, 2007 7:03 pm

Mark col2 and col3 on the output as Key, and let DataStage generate the UPDATE statement. Choose "update existing rows only" as the update strategy.

sachin1 · Post by **sachin1** » Tue Jul 17, 2007 12:58 am

marking other columns as key marks these keyed column to be used for where condition in update clause by oracle stage