The followings are the steps for the setup:
For each source,
- Start the extract at the source DB
- Create the new target DB/Tables and import data from source DB to the target DB/Tables
This normally involved the import/export tools or the backup tools like Oracle RMAN.
- Start the replicat at the new DB with HANDLECOLLISIOINS.
The collisions only happens if there are transactions after extract is started and before exporitng data from the old DB (between step 1 and 2)
Note: After GoldenGate 12.1.2, you can also use the start replicat with afterCSN to atCSN to avoid handling collisions.
- Checke the lag and remove HANDLECOLLISIOINS after repliat catches up (no lag)
<--- Now, the target DB should be synced up with the source DB (Data Warehouse Staging DB/Table)