News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

8 Comments

shubha
  • Jun 5 2010
Hi Ur documents are very good for basic configuration. We have one query - can we replicate data if table having differnt number of columns on source & target database. suppose source database have 1 table with 10 columns,target database have 5 columns on that table. Waiting for your reply Thanks in advance
Gavin Soorma
  • Jun 8 2010
Hi Shubha - yes it is certainly possible - we can change table structure on the target - column names are different - data types are different - columns are fewer etc etc - read page 247 of the GoldenGate Administration Guide - it has reference to COLS and COLSEXCEPT keywords which basically enables us to specify the columns to include or exclude from the replication process - try it out and let me know how it goes as I have not tried that feature - thanks
Vinay Kumar
  • Sep 13 2010
Hi Gavin, Is it possible to map tables with different structure. Like in Source table we have 3 columns but in target table we want only 2 columns. How do we achieve that? Thanks in advance. Regards, Vinay Kumar G
Gavin Soorma
  • Sep 22 2010
Hi there is the COLMAP clause - have a look at the documentation Windows and Unix Administration Guide for more information
victor
  • Feb 25 2011
Hi Gavin, we are building a real-time ODS sourcing several Oracle OLTP systems, and want to run PL/SQL package at target to do an ETL-like transform at the end of GG replication, all synchronous, using GG as the invoker of the PL/SQL package. could you be kind enough to give an example of how one would source let's say INVOICE headers, lines, and CUSTOMERS using GG, and then transform related records, namely invoice header, associated lines, and associated customer with a PL/SQL call, combining new CDC data for the sub-set that came from GG with already resident data on the target.. basic ETL pattern using both source and target data, all in GG.. Is this doable? thanks so much in advance!
Pradeep Gupta
  • Jun 15 2011
Good work Gavin, I am having 3 years of good exp in GoldenGate. I went thru some of your documents and found very clear and nicely written. Many thanks for all your blogs, I will surely recommend your site for beginners. Cheers
Parry
  • Jun 21 2012
Hi Gavin, Thanks for your tutorial. Question.. how would we handle records to be loaded in a target table only when they are new inserts? I don't need to load any updates to a table, as I need to preserve the initial inserted value. Thanks, Parry
Gavin Soorma
  • Jun 26 2012
Hi Parry - it's possible - will try it out in the next couple of days and put out a post on the same

Leave Reply

Your email address will not be published. Required fields are marked *