Categories
Limit a delete stmt based on condition in goldengate
User_PHC09
Orion GCS Customer Posts: 1 Green Ribbon
in General
Hi experts
When OGG encounters a delete record, it should only process those where the gen_date > Current_Date and salary = null and Ind = null.
how can i achieve above in goldengate
ALLOWDUPTARGETMAP
--MAP pdb1.target., TARGET pdb1.target.;
IGNOREDELETES
MAP pdb1.source.emp1, TARGET pdb1.target.emp1;
IGNOREINSERTS
IGNOREUPDATES
GETDELETES
MAP pdb1.source.emp1, TARGET pdb1.target.emp1, WHERE (salary <>@null and ind <>@null)
something like above .. but it is not working .. more over is a it possible to achieve it in a single map stmt so that i can use it in integrated replcat
0