Warning: Creating default object from empty value in /home/customer/www/gavinsoorma.com/public_html/wp-content/themes/specular/admin/inc/class.redux_filesystem.php on line 29 Oracle Goldengate Tutorial 8 – Filtering and Mapping data | Oracle DBA – Tips and Techniques
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
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
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
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!
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
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
8 Comments