- I have a task to replicate unidirectional real time data from source database A to target database B. I do not need all the table from A, only few tables and few columns inside those tables. Say 10 tables and 30 columns from A go into 6 tables on database B.
Is this doable in Golden Gate (GG)? Oracle 11g source and 12c target DB version in same OS version.
- In addition to the above, when GG is replicating can it insert a sequence number on a column/table in database B?
Any links you can point, as how to do the above is very much appreciated?