Forum Stats

  • 3,769,802 Users
  • 2,253,023 Discussions
  • 7,875,210 Comments

Discussions

Limit a delete stmt based on condition in goldengate

User_PHC09
User_PHC09 Member Posts: 28 Employee

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

Tagged:

Answers