Limit a delete stmt based on condition in goldengate
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
--MAP pdb1.target., TARGET pdb1.target.;
MAP pdb1.source.emp1, TARGET pdb1.target.emp1;
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