This discussion is archived
3 Replies Latest reply: Jan 28, 2013 9:37 PM by Bhabani Ranjan RSS

SQL Control Append - but change previous rows

930307 Newbie
Currently Being Moderated
Hi, I am new to ODI and can not work out how to do the following.

I want to create an interface that :

1) Appends rows to the existing target table
2) changes the current_flg to "Y" for the most recently appended rows
3) changes the current_flg to "N" for all other rows

1) is OK, I am using the IKM SQL Control Append
2) is OK, as in the interface I set current_flg to 'Y'
3) - I can not work out how to do this. There is effectively no link between then "old" and newly appended rows , and no primary Key, so I do not think incremental or scd IKM is appropriate.

Any suggestions?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points