Initial load with filtering and mapping

Hi All,

We've bi-directional replication between two Oracle Databases. There are some records which are out-of-sync between two databases.

We'd both the databases serving traffic at a certain point in time causing some conflicts. We've a modifieddate field which we want to keep the latest one.

Say row1 in DB A is updated later so apply that timestamp to other DB for same records. Same way we want to apply row2 which is updated later at DB B to DB A.

I know we can do that using SQLEXEC in map statement for online change synchronization but not sure if that will work for Initial Load as well.