Goldengate synchronization non-primary key table

The Scott. Bonus table does not have a primary key and does not have a unique index. If it is sent from the GG source end, the GG target end is abend, unless the target replication process parameter file has applynoopupdates or allownoopupdates parameters)

Update Scott. T1 set ename = 'bos 'where ename = 'bos2 ';

When the GG destination is abend, The rpt file in dirrpt reports the following error:

09:35:23 error OGG-01168 encountered an update for target table scott2.bonus, which has no unique key defined. keycols can be used to define a key.
Use allownoopupdates to process the update without applying it to the target database.
Use applynoopupdates to force the update to be applied using all columns in both the set and where clause

 

Therefore, add the applynoopupdates or allownoopupdates parameter to the target configuration file.