filter row set golden gate extract
edited Jan 1, 2016 10:01AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
Hello Experts,
i am trying to filter set of rows during extract. here is my where clause i am using and below is my param file
-- Name of the extract process.
EXTRACT ef1htst1
-- Oracle environment settings.
obey ./diroby/fadbq.env
-- OGG database user login
obey ./diroby/fadbq_login.oby
-- Local trail info
EXTTRAIL ./dirdat/fadbq/t1
TRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 300, parallelism 2)
-- List of tables
table fadmin.SECRTY_LOGIN_AUDIT_BKP, sqlpredicate "WHERE upper(active_tenant_cd) not in ('FI_BASE_TENANT','SEEDDATATENANT')";
somehow my filter condition is not working as expected.
i have total 884 record on the database
Tagged:
0