I am trying to replace snapshot with goldengate and realized that PK updates on source are not replicating to target with Filter.
Also if i update on source to some not matching condition in filter unlike snapshot it does not delete record from replication.
I understand goldengate is not snapshot but any workaround to achieve this ?
Thank you for your time.
We have used Filter on Replicat level.
MAP PANMO.DISCOUNT_STORE, TARGET GGTEST.DISCOUNT_STORE, COLMAP (USEDEFAULTS),KEYCOLS (STORE_NAME,DISTOUNT_ID,SEQ_NO,Entry_DATE),
(((@STREQ(DISTOUNT_ID,"11111") = 0 ) OR (@STRCMP(DISTOUNT_ID,"11111") = 0 AND @STREQ(STORE_NAME,"PETE") = 1 ))
(@COLTEST(Entry_DATE,NULL) OR @STRCMP (@DATE ("YYYY-MM-DD", "YYYY-MM-DD HH:MI:SS",Entry_DATE), "2011-08-28" ) >=0 );
I don't know if it's this simple, but as I tried to reformat the FILTER expression to figure out what you were doing, I got lost a few times... so I pasted the entire MAP statement into Microsoft Word and did a replace all on the "(" and it found 14. Then I did a replace all on the ")" and it found only 12.
So, it could be that you are missing two close parenthesis. ")" ... but I'm not exactly sure where they should go, because of the AND / OR combinations.
Syntax wise, everything looks correct, and I don't see any problems.