Hi,
Am using GG on 12c DBs . Both source and target.
Am trying to do an initial load, where am trying to filter data based on two tables from source side.
Am trying to filter on source side and send it on to target.
The requirement is If any insert/update/delete happens on App_table1, it should first check whether the columns exist on KEY_DRIVER table and if exists, the row should move to the target.
My load file on source looks like.
EXTRACT PLOAD
userid ggsource1, password xxxx
RMTHOST 10.193.xxx.xx, MGRPORT 7810
RMTTASK REPLICAT, GROUP PLOAD2
TABLE SCOTT.KEY_DRIVER;
TABLE SCOTT.APP_TABLE1, &
SQLEXEC (ID lookup, &
QUERY "SELECT * FROM SCOTT.APP_TABLE1 A, SCOTT.KEY_DRIVER B WHERE A.KEYFIELD_A=B.KEYFIELD_A AND A.KEYFIEL
D_B=B.KEYFIELD_B AND A.KEYFIELD_C=B.KEYFIELD_C", NOPARAMS);
But all the rows from source are sent to the target. They are not getting filtered.