Limit a delete stmt based on condition in goldengate

User_PHC09
User_PHC09 Orion GCS Customer Posts: 1 Green Ribbon

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