I'm trying to determine how suitable Goldengate bi-directional replication will be with my application and the main concern right now is to do with conflict detection and resolution.
When it comes to specifying RESOLVECONFLICT parameters for individual tables, how do you best manage when there are additional DML updates in the same database transaction as one that causes a conflict?
For example, a conflict occurs in a transaction and then there are further statements in that transaction that depend on the outcome of that earlier conflict.
Does anyone have any advice or useful links that explain ways on how to approach this?
Thanks in advance.