I have a process where I have to check to see if a record exists in a table. I am using decision shape to check for existence of the record. If it exists I update the record. If not I insert a record.
When I update the record, before updating I have to get few fields in teh table and store them somewhere. After that I have to check if the values for those fields in the table and the values that are now coming in are same or different. If they are same, I will have to update the record but also mark a field called ActFlag to "None". If they are different, update the record and also in the ActFlag field insert "Update".
What is the best way to achieve this?