Addition of new table to existing goldengate setup.

Hi,

scenario is quite different here. so your valuable suggestions and recommendations will be very helpful for me.

1> I have an goldengate setup in which having different source databases.

2> Schema and table name of all Source databases is similar.

3> replicating all the tables of all database to one single reporting database.

4> also having same table and schema name toward reporting/target side.

5> all tables on target side have one additional column that representsunique identity of source database.

for eg: in target database in every table we have server_id column extra which shows from which database 1,2 or 3 data is coming.