Filter not take effect
We have replicate OGG 12.3 and DB Oracle 12.1.0.2 , The belwo fillter not take effect
REPLICAT rephuat
SETENV (ORACLE_HOME = '/oraivr/app/oracle/product/12.1.0/dbhome_1')
SETENV (TNS_ADMIN = '/oraivr/app/oracle/product/12.1.0/dbhome_1/network/admin')
--- SETENV (ORACLE_SID="pgsit2")
USERID ogg_admin@pgsit, PASSWORD oracle
---SETENV (ORACLE_SID="PGNCSIT2")
--- USERID ogg_admin@PGNCSIT2, PASSWORD oracle
---- SOURCECHARSET PASSTHRU
MAP CISADM.HAYAT_ONLINE_STG, TARGET ogg_admin.HAYAT_ONLINE_STG, where (CIS_DIVISION <> 'TCBU' or CIS_DIVISION <> 'MCBU' or CIS_DIVISION=@NULL);
MAP CISADM.test, target ogg_admin.test;