Monday, May 2, 2016

Exclude Table During MAP !



EXT1 :

GGSCI (pbltest.pbl.com) 14> edit params ext1
EXTRACT ext1
USERID ggs_owner, PASSWORD ggs_owner
SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/db_1")
SETENV (ORACLE_SID = "PRIMPBL")
SETENV (NLS_LANG=".WE8MSWIN1252")
EXTTRAIL /u02/oracle/software/goldengate/dirdat/lt
WILDCARDRESOLVE IMMEDIATE
TRANLOGOPTIONS INCLUDEREGIONID
--DYNAMICRESOLUTION
--EOFDELAY 60
TABLEEXCLUDE ULTIMUSISL.CLEARING_HOUSE_NO
TABLEEXCLUDE ULTIMUSISL.GTMP_MIS_GL_SUPPL
TABLEEXCLUDE ULTIMUSISL.TMP_OUT_DBF_FILE
TABLEEXCLUDE ULTIMUSISL.TMP_RPT_CL1
TABLEEXCLUDE ULTIMUSISL.TMP_SMS_FUNCTION_ACCESS
TABLEEXCLUDE ULTIMUSISL.TMP_SMS_MENU_ACCESS
TABLEEXCLUDE ULTIMUSISL.TMP_YEAR_CLD
TABLEEXCLUDE ULTIMUSISL.TODAY_SALES
TABLEEXCLUDE ULTIMUSISL.TMP_CALENDAR
TABLEEXCLUDE ULTIMUSISL.TMP_COR_LON_COMMIT_TRAN
TABLE ULTIMUSISL.*

No comments: