Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can COLMAP call a User Defined Function?

WoodyMcKayApr 18 2013 — edited Apr 19 2013
Hi, I'm new to GoldenGate. We are replicating many source databases into a single target database. All source databases have the same schema but with different data. I need to generate a GUID to insert into a new column in every table in the source database. Can I do this with COLMAP? If so, how can I generate a GUID with COLMAP?

If this is not possible, what would be a good solution? Should we use BEFORE INSERT triggers in the source DB to insert the GUID? The guid column is only on the target DB and not in the source DB.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 17 2013
Added on Apr 18 2013
1 comment
214 views