Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Limit a delete stmt based on condition in goldengate

User_PHC09
Member Posts: 28 Employee
in GoldenGate
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
-
Experts,
Any thoughts on this