Database Consolidation using Oracle GoldenGate

 Hi Everybody.

We want to consolidate our target database using n nos of source databases. All these dbs are in active state (i.e. used by end users)

For e.g.

DB1 (Source 1)

Study: id (1000000)

 ---- Series: id(1000099); study_uid(1000000)

 ---- Image:  id(1000888); series_uid(1000099); study_uid(1000000)

 ---- Image Version: id(1000000) image_uid(1000888)

DB2 (Source 2)

Study: id (1000000)

 ---- Series: id(1000097); study_uid(1000000)

 ---- Image:  id(1000777); series_uid(1000097); study_uid(1000000)

 ---- Image Version: id(1000000) image_uid(1000777)

DBTarget: (Target DB)

This database will have records from the above DBs as well as its own records. Please note that this db might have Study ID = 1000000.