OGG pump进程过滤分发数据

分发进程test_pu

GGSCI (localhost) 1> add extract test_pu exttrailsource ./dirdat/ea, begin now
GGSCI (localhost) 2> add rmttrail ./dirdat/te extract test_pu
GGSCI (localhost) 3> edit params test_pu

extract test_pu
passthru
rmthost 127.0.0.1, mgrport 7809     //投递到本地进行测试
rmttrail ./dirdat/te

table db_meta.scetc.TBL_ENWASTE, FILTER (@STRFIND (bl_center,'001') > 0 or @STRFIND (bl_center,'002') > 0);      //选取bl_center in ('001','002')的数据

 

复制进程test_re

GGSCI (localhost) 1> add replicat test_re integrated exttrail ./dirdat/te
GGSCI (localhost) 2> view param test_re

replicat test_re
userid ogg@orcl_43, password ogg
reperror (-1, discard)
discardrollover  at 02:00
discardfile ./dirrpt/test_re.dsc, purge, megabytes 1000
reperror default, abend
report at 01:59
reportrollover at 02:00
reportcount every 2 minutes, rate

map db_meta.scetc.TBL_ENWASTE, target s05.TBL_ENWASTE1;