I am having requirement in which I need to use SQLEXEC with Procedure & FILTER parameters.
Filtering will be based on target side column which is not available at source side, that means I can not use FILTER Clause in MAP statement.
I have gone through The Guidelines for using a standalone SQLEXEC parameter on page 294 of gg_wux_ref but not getting about how can I use SQLEXEC with Filter clause & filtering also has a condition i.e. I need to check the distinct value of 500 rows table & if distinct value is 0, I will use EVENTACTIONS to stop replicat.
Can someone please suggest me on the same.