Does anyone have a method of doing this?
The reason why I need it is that I have a new record which has then been updated coming in on the same pipeline. I need to add the new record to the target table first then make the change to that same record in place.
Any ideas?