Can COLMAP call a User Defined Function?
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.