This discussion is archived
0 Replies Latest reply: Oct 15, 2013 6:04 AM by Santosh Pradhan RSS

Oracle Golden gate to use SQLEXEC & Filter clause

Santosh Pradhan Explorer
Currently Being Moderated

Hi,

 

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.

 

Thank you!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points