GoldenGate - update statement not working when primary keys are different
Hi,
I'm trying to set up replication in oracle between two tables, similar cols, but different primary key.
Insert and deletes are working, but update.
Here are detail
create table nil_test ( c1 number,c2 number,c3 varchar2(10));
create table nil_test_rep ( c1 number,c2 number,c3 varchar2(10));
alter table nil_test add primary key (c1);
alter table nil_test_rep add primary key (c2,c1);
alter table nil_test add supplemental log data (all) columns;
-- in gg
add trandata X5.nil_test cols(c1,c2,c3), NOKEY
extract E_GG1NIL
userid ggs_user@GGTEST1,password ggs_user;