GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

how to handle additional increment column in target database with goldengate?

In my situation, I'm doing a initialization in MySQL by moving data from oracle table. there is no auto increment column in oracle table, but the MySQL table has such column, say id column. ideally, the id column will not appear in the funcition colmap in replicat configuration. Unfortunately, I got the below error:
Error with default mapping. No matching fields found in source and target
The following target columns were not mapped:
id

is there any solution for this? I think the mysql column auto increment column can work well, during the initialization, we only do inserting by employing the extract and replicat.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center