Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Update a Flag value in Target table

988115Apr 26 2013 — edited May 31 2013

Hi All,

I have a Target table named Student which consists of SID, Sname, Sdob and Sflag columns. I need to update the Sflag value as 1 when ever there is an update occurs to the existing records or a new record is inserted into Student table.

My source is SQl server and target is Oracle.
My LKM is LKM SQL to Oracle and IKM is IKM SQL Control Append.

Please help me how to achieve this.

Thanks a Lot.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 28 2013

Added on Apr 26 2013

#business-intelligence-applications, #data-integrator, #system-management-and-integration

6 comments

740 views