How do I handle capturing the actual update statement (and not its result) in a journal mapping?
You can do journal mapping to enable the details of any update activity on a table to be captured and recorded on a target table known as a journal. This is a log at a target server that can track the changes made to a source table, useful for auditing, for example.
Journal mapping captures the “before” values in an update statement to know what changed. Use this process if you want to check the accuracy of entries, to see, for example, if representatives are “rounding up” when they enter data, you might use journal mapping to re-create their entries and see the changes. You could also use this feature to see exactly what changes were made to the record when a phone line went down.
It is possible to replicate a source table to both a journal table and a normal target table on the same server.