--=================================== -- VERSION 119 -- EDIT DATE: 22-AUG-17 -- EDIT BY: DJR/DFI --=================================== REPLICAT RATGUNCL SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8) -- VERSION 103: DA 11/12/2014 ADDED TNS CONNECTION TO USERID FOR RAC COMPLIANCE USERID xx@PTBSN, PASSWORD xx ASSUMETARGETDEFS DBOPTIONS SUPPRESSTRIGGERS DISCARDFILE ./dirrpt/DISC/ratguncl.dsc, MEGABYTES 2000, APPEND -- As per oracle SR added the following for rollover on 09/26/2013 due to CDR issue creating big dsc file. DISCARDROLLOVER AT 01:00 DISCARDROLLOVER AT 05:00 DISCARDROLLOVER AT 09:00 DISCARDROLLOVER AT 13:00 DISCARDROLLOVER AT 17:00 DISCARDROLLOVER AT 21:00 GROUPTRANSOPS 2000 EOFDELAYCSECS 20 --20130606 SIMON'S CHANGES REPERROR (DEFAULT, EXCEPTION) APPLYNOOPUPDATES REPORTCOUNT EVERY 100000 RECORDS, RATE REPORT ON SUNDAY AT 00:30 REPORTROLLOVER AT 01:00 ON SUNDAY --=================================== -- CONFLICT RESOLUTION MAPS --=================================== MAP BBB_CORE.DCSPP_PAY_GROUP, TARGET BBB_CORE.DCSPP_PAY_GROUP; MAP BBB_CORE.DCSPP_AUTH_STATUS, TARGET BBB_CORE.DCSPP_AUTH_STATUS; MAP BBB_CORE.DCSPP_PAY_INST, TARGET BBB_CORE.DCSPP_PAY_INST; MAP BBB_CORE.DCSPP_STORE_CRED, TARGET BBB_CORE.DCSPP_STORE_CRED; MAP BBB_CORE.DCSPP_BILL_ADDR, TARGET BBB_CORE.DCSPP_BILL_ADDR; MAP BBB_CORE.DCSPP_GIFT_CERT, TARGET BBB_CORE.DCSPP_GIFT_CERT; MAP BBB_CORE.DCSPP_DEBIT_STATUS, TARGET BBB_CORE.DCSPP_DEBIT_STATUS; MAP BBB_CORE.DCSPP_CRED_STATUS, TARGET BBB_CORE.DCSPP_CRED_STATUS; MAP BBB_CORE.DCSPP_CREDIT_CARD, TARGET BBB_CORE.DCSPP_CREDIT_CARD; --=================================== -- INCLUDE FILE --=================================== -- VERSION 118: DJR 6/1/2017 - Release3 + separation of INC -- INCLUDE FILE INCLUDE ./dirprm/ratg.inc --=================================== -- TESTING TABLE INCLUDES --=================================== MAP GGS_TEST.*, TARGET GGS_TEST.*; MAP BBB_PIM_STG.*, TARGET BBB_PIM_STG.*; MAP BBB_SWITCH_A.*, TARGET BBB_SWITCH_A.*; MAP BBB_SWITCH_B.*, TARGET BBB_SWITCH_B.*; MAP BBB_CORE_PRV.*, TARGET BBB_CORE_PRV.*; MAP BBB_PUB.*, TARGET BBB_PUB.*; -- VERSION 119: DJR 22-AUG-17 - Added New Schema MAP BBB_GG.*, TARGET BBB_GG.*; MAP BBB_GG_PRV.*, TARGET BBB_GG_PRV.*; --20130606 SIMON'S CHANGES -- VERSION 106A - CHG0524653 PINPOINT EXCEPTION REPORTING -- REPLACES ANNAPOLIS/SAN DIEGO WITH REPLICAT NAME MAP BBB_CORE.*, TARGET GGS.EXCEPTIONS , COLMAP ( REP_NAME = 'RATGUNCL' , SCHEMA_NAME = 'BBB_CORE' , TABLE_NAME = @GETENV ('GGHEADER', 'TABLENAME') , ERRNO = @GETENV ('LASTERR', 'DBERRNUM') , DBERRMSG = @GETENV ('LASTERR', 'DBERRMSG') , OPTYPE = @GETENV ('LASTERR', 'OPTYPE') , ERRTYPE = @GETENV ('LASTERR', 'ERRTYPE') , LOGRBA = @GETENV('RECORD', 'FILESEQNO') , LOGPOSITION = @GETENV('RECORD', 'FILERBA') , COMMITTIMESTAMP = @GETENV ('GGHEADER', 'COMMITTIMESTAMP')) , INSERTALLRECORDS , EXCEPTIONSONLY; MAP BBB_SWITCH_A.*, TARGET GGS.EXCEPTIONS , COLMAP ( REP_NAME = 'RATGUNCL' , SCHEMA_NAME = 'BBB_SWITCH_A' , TABLE_NAME = @GETENV ('GGHEADER', 'TABLENAME') , ERRNO = @GETENV ('LASTERR', 'DBERRNUM') , DBERRMSG = @GETENV ('LASTERR', 'DBERRMSG') , OPTYPE = @GETENV ('LASTERR', 'OPTYPE') , ERRTYPE = @GETENV ('LASTERR', 'ERRTYPE') , LOGRBA = @GETENV('RECORD', 'FILESEQNO') , LOGPOSITION = @GETENV('RECORD', 'FILERBA') , COMMITTIMESTAMP = @GETENV ('GGHEADER', 'COMMITTIMESTAMP')) , INSERTALLRECORDS , EXCEPTIONSONLY; MAP BBB_SWITCH_B.*, TARGET GGS.EXCEPTIONS , COLMAP ( REP_NAME = 'RATGUNCL' , SCHEMA_NAME = 'BBB_SWITCH_B' , TABLE_NAME = @GETENV ('GGHEADER', 'TABLENAME') , ERRNO = @GETENV ('LASTERR', 'DBERRNUM') , DBERRMSG = @GETENV ('LASTERR', 'DBERRMSG') , OPTYPE = @GETENV ('LASTERR', 'OPTYPE') , ERRTYPE = @GETENV ('LASTERR', 'ERRTYPE') , LOGRBA = @GETENV('RECORD', 'FILESEQNO') , LOGPOSITION = @GETENV('RECORD', 'FILERBA') , COMMITTIMESTAMP = @GETENV ('GGHEADER', 'COMMITTIMESTAMP')) , INSERTALLRECORDS , EXCEPTIONSONLY; MAP BBB_PUB.*, TARGET GGS.EXCEPTIONS , COLMAP ( REP_NAME = 'RATGUNCL' , SCHEMA_NAME = 'BBB_PUB' , TABLE_NAME = @GETENV ('GGHEADER', 'TABLENAME') , ERRNO = @GETENV ('LASTERR', 'DBERRNUM') , DBERRMSG = @GETENV ('LASTERR', 'DBERRMSG') , OPTYPE = @GETENV ('LASTERR', 'OPTYPE') , ERRTYPE = @GETENV ('LASTERR', 'ERRTYPE') , LOGRBA = @GETENV('RECORD', 'FILESEQNO') , LOGPOSITION = @GETENV('RECORD', 'FILERBA') , COMMITTIMESTAMP = @GETENV ('GGHEADER', 'COMMITTIMESTAMP')) , INSERTALLRECORDS , EXCEPTIONSONLY; MAP BBB_PIM_STG.*, TARGET GGS.EXCEPTIONS , COLMAP ( REP_NAME = 'RATGUNCL' , SCHEMA_NAME = 'BBB_PIM_STG' , TABLE_NAME = @GETENV ('GGHEADER', 'TABLENAME') , ERRNO = @GETENV ('LASTERR', 'DBERRNUM') , DBERRMSG = @GETENV ('LASTERR', 'DBERRMSG') , OPTYPE = @GETENV ('LASTERR', 'OPTYPE') , ERRTYPE = @GETENV ('LASTERR', 'ERRTYPE') , LOGRBA = @GETENV('RECORD', 'FILESEQNO') , LOGPOSITION = @GETENV('RECORD', 'FILERBA') , COMMITTIMESTAMP = @GETENV ('GGHEADER', 'COMMITTIMESTAMP')) , INSERTALLRECORDS , EXCEPTIONSONLY; MAP BBB_CORE_PRV.*, TARGET GGS.EXCEPTIONS , COLMAP ( REP_NAME = 'RATGUNCL' , SCHEMA_NAME = 'BBB_CORE_PRV' , TABLE_NAME = @GETENV ('GGHEADER', 'TABLENAME') , ERRNO = @GETENV ('LASTERR', 'DBERRNUM') , DBERRMSG = @GETENV ('LASTERR', 'DBERRMSG') , OPTYPE = @GETENV ('LASTERR', 'OPTYPE') , ERRTYPE = @GETENV ('LASTERR', 'ERRTYPE') , LOGRBA = @GETENV('RECORD', 'FILESEQNO') , LOGPOSITION = @GETENV('RECORD', 'FILERBA') , COMMITTIMESTAMP = @GETENV ('GGHEADER', 'COMMITTIMESTAMP')) , INSERTALLRECORDS , EXCEPTIONSONLY; -- VERSION 113A: DJR 25-SEP-16 HYDRA BBB_MISC EXCEPTIONS MAP BBB_MISC.*, TARGET GGS.EXCEPTIONS , COLMAP ( REP_NAME = 'RATGUNCL' , SCHEMA_NAME = 'BBB_MISC' , TABLE_NAME = @GETENV ('GGHEADER', 'TABLENAME') , ERRNO = @GETENV ('LASTERR', 'DBERRNUM') , DBERRMSG = @GETENV ('LASTERR', 'DBERRMSG') , OPTYPE = @GETENV ('LASTERR', 'OPTYPE') , ERRTYPE = @GETENV ('LASTERR', 'ERRTYPE') , LOGRBA = @GETENV('RECORD', 'FILESEQNO') , LOGPOSITION = @GETENV('RECORD', 'FILERBA') , COMMITTIMESTAMP = @GETENV ('GGHEADER', 'COMMITTIMESTAMP')) , INSERTALLRECORDS , EXCEPTIONSONLY; -- VERSION 119: DJR 01-AUG-17 - Added New Schema MAP BBB_GG.*, TARGET GGS.EXCEPTIONS , COLMAP ( REP_NAME = 'RATGUNCL' , SCHEMA_NAME = 'BBB_GG' , TABLE_NAME = @GETENV ('GGHEADER', 'TABLENAME') , ERRNO = @GETENV ('LASTERR', 'DBERRNUM') , DBERRMSG = @GETENV ('LASTERR', 'DBERRMSG') , OPTYPE = @GETENV ('LASTERR', 'OPTYPE') , ERRTYPE = @GETENV ('LASTERR', 'ERRTYPE') , LOGRBA = @GETENV('RECORD', 'FILESEQNO') , LOGPOSITION = @GETENV('RECORD', 'FILERBA') , COMMITTIMESTAMP = @GETENV ('GGHEADER', 'COMMITTIMESTAMP')) , INSERTALLRECORDS , EXCEPTIONSONLY; MAP BBB_NON_GG.*, TARGET GGS.EXCEPTIONS , COLMAP ( REP_NAME = 'RATGUNCL' , SCHEMA_NAME = 'BBB_NON_GG' , TABLE_NAME = @GETENV ('GGHEADER', 'TABLENAME') , ERRNO = @GETENV ('LASTERR', 'DBERRNUM') , DBERRMSG = @GETENV ('LASTERR', 'DBERRMSG') , OPTYPE = @GETENV ('LASTERR', 'OPTYPE') , ERRTYPE = @GETENV ('LASTERR', 'ERRTYPE') , LOGRBA = @GETENV('RECORD', 'FILESEQNO') , LOGPOSITION = @GETENV('RECORD', 'FILERBA') , COMMITTIMESTAMP = @GETENV ('GGHEADER', 'COMMITTIMESTAMP')) , INSERTALLRECORDS , EXCEPTIONSONLY; MAP BBB_GG_PRV.*, TARGET GGS.EXCEPTIONS , COLMAP ( REP_NAME = 'RATGUNCL' , SCHEMA_NAME = 'BBB_GG_PRV' , TABLE_NAME = @GETENV ('GGHEADER', 'TABLENAME') , ERRNO = @GETENV ('LASTERR', 'DBERRNUM') , DBERRMSG = @GETENV ('LASTERR', 'DBERRMSG') , OPTYPE = @GETENV ('LASTERR', 'OPTYPE') , ERRTYPE = @GETENV ('LASTERR', 'ERRTYPE') , LOGRBA = @GETENV('RECORD', 'FILESEQNO') , LOGPOSITION = @GETENV('RECORD', 'FILERBA') , COMMITTIMESTAMP = @GETENV ('GGHEADER', 'COMMITTIMESTAMP')) , INSERTALLRECORDS , EXCEPTIONSONLY; MAP BBB_NON_GG_PRV.*, TARGET GGS.EXCEPTIONS , COLMAP ( REP_NAME = 'RATGUNCL' , SCHEMA_NAME = 'BBB_NON_GG_PRV' , TABLE_NAME = @GETENV ('GGHEADER', 'TABLENAME') , ERRNO = @GETENV ('LASTERR', 'DBERRNUM') , DBERRMSG = @GETENV ('LASTERR', 'DBERRMSG') , OPTYPE = @GETENV ('LASTERR', 'OPTYPE') , ERRTYPE = @GETENV ('LASTERR', 'ERRTYPE') , LOGRBA = @GETENV('RECORD', 'FILESEQNO') , LOGPOSITION = @GETENV('RECORD', 'FILERBA') , COMMITTIMESTAMP = @GETENV ('GGHEADER', 'COMMITTIMESTAMP')) , INSERTALLRECORDS , EXCEPTIONSONLY; --============================================================