經(jīng)營分析系統(tǒng)測試大綱(ELT案例)

廣東省分行經(jīng)營分析系統(tǒng)測試大綱ELT測試案例經(jīng)營分析系統(tǒng)測試大綱(ELT案例)第1頁共155頁目錄1 數(shù)據(jù)抽取及加載的測試案例 11.1 AI（內(nèi)部核算）子系統(tǒng)測試案例 11.2 CC（信用卡）子系統(tǒng)測試案例 61.3 CD（支票）子系統(tǒng)測試案例 111.4 CI（客戶信息）子系統(tǒng)測試案例 131.5 CS（銀行卡）子系統(tǒng)測試案例 171.6 CT（出納表外）子系統(tǒng)測試案例 181.7 CY（同城票據(jù)交換）子系統(tǒng)測試案例 211.8 EF（定期借記）子系統(tǒng)測試案例 231.9 FX（外匯買賣）子系統(tǒng)測試案例 251.10 IB（聯(lián)行往來）子系統(tǒng)測試案例 261.11 MC（一卡通）子系統(tǒng)測試案例 301.12 SC（系統(tǒng)控制）子系統(tǒng)測試案例 301.13 SD（單折活期）子系統(tǒng)測試案例 321.14 SW（SWITCH）子系統(tǒng)測試案例 351.15 TDN（國債）子系統(tǒng)測試案例 351.16 TD（單折定期）子系統(tǒng)測試案例 372 數(shù)據(jù)轉(zhuǎn)換測試案例（全量環(huán)境） 452.1 PARTY團體主題域測試案例(PRTY) 452.1.1 PRTY001–團體數(shù)目測試 452.1.2 PRTY002–團體關(guān)系測試 512.1.3 PRTY003–個人屬性信息測試 542.1.4 PRTY004–團體地址/電話/電子地址測試 552.1.5 PRTY005–團體歷史記錄增量測試 642.2 ACCOUNT帳戶主題域測試案例(ACCT) 652.2.1 ACCT001–活期賬戶數(shù)目測試 652.2.2 ACCT002–定期賬戶數(shù)目測試 672.2.3 ACCT003–支票賬戶數(shù)目測試 702.2.4 ACCT004–信用卡賬戶數(shù)目測試 712.2.5 ACCT005–內(nèi)部賬戶數(shù)目測試 732.2.6 ACCT006–表外賬戶數(shù)目測試 742.2.7 ACCT007–賬戶關(guān)系測試 762.2.8 ACCT008–總賬測試 772.2.9 ACCT009–賬戶產(chǎn)品測試 782.2.10 ACCT010–賬戶與團體關(guān)系測試 792.2.11 ACCT011–卡數(shù)目測試 812.2.12 ACCT012–賬戶與卡關(guān)系測試 822.2.13 ACCT013–賬戶余額測試 832.2.14 ACCT014–賬戶狀態(tài)歷史測試 862.3 EVENT事件主題域測試案例(EVNT) 872.3.1 EVNT001–事件數(shù)目測試(活期) 872.3.2 EVNT002–事件數(shù)目測試(定期) 892.3.3 EVNT003–事件數(shù)目測試(信用卡) 902.3.4 EVNT004–事件數(shù)目測試(支票) 922.3.5 EVNT005–事件數(shù)目測試(表外帳戶) 932.3.6 EVNT006–事件數(shù)目測試(內(nèi)部賬戶) 952.3.7 EVNT007–特定賬戶事件測試 962.3.8 EVNT008–特定卡事件測試 972.4 INTERNALORGANIZATION內(nèi)部機構(gòu)主題域測試案例(IORG) 992.4.1 IORG001–銀行機構(gòu)測試 992.4.2 IORG002–銀行關(guān)系測試 1002.5 CHANNEL渠道主題域測試案例(CHNL) 1012.5.1 CHNL001–渠道測試 1012.6 PRODUCT產(chǎn)品主題域測試案例(PROD) 1022.6.1 PROD001–產(chǎn)品類型測試 1022.6.2 PROD002–產(chǎn)品子類型測試 1022.6.3 PROD003–產(chǎn)品分類測試 1022.6.4 PROD004–產(chǎn)品詳細定義測試 1022.7 LOCATION地理位置主題域測試案例(GEOG) 1032.7.1 GEOG001–地理位置測試 1032.8 MINOR代碼表主題域測試案例(MINR) 1042.8.1 MINR001–代碼參照表測試 1042.8.2 MINR002–產(chǎn)品參照表測試 1043 數(shù)據(jù)轉(zhuǎn)換測試案例(增量環(huán)境) 1053.1 PARTY團體主題域測試案例(PRTY) 1053.1.1 PRTY001–團體數(shù)目測試 1053.1.2 PRTY002–團體關(guān)系測試 1083.1.3 PRTY003–團體歷史記錄增量測試 1093.2 ACCOUNT帳戶主題域測試案例(ACCT) 1103.2.1 ACCT001–活期賬戶數(shù)目測試 1103.2.2 ACCT002–定期賬戶數(shù)目測試 1123.2.3 ACCT003–支票賬戶數(shù)目測試 1193.2.4 ACCT004–信用卡賬戶數(shù)目測試 1213.2.5 ACCT005–內(nèi)部賬戶數(shù)目測試 1243.2.6 ACCT006–表外賬戶數(shù)目測試 1263.2.7 ACCT007–賬戶關(guān)系測試 1283.2.8 ACCT008–卡數(shù)目測試 1293.2.9 ACCT009–賬戶余額測試 1303.3 EVENT事件主題域測試案例(EVNT) 1333.3.1 EVNT001–事件數(shù)目測試(活期) 1333.3.2 EVNT002–事件數(shù)目測試(定期) 1353.3.3 EVNT003–事件數(shù)目測試(信用卡) 1363.3.4 EVNT004–事件數(shù)目測試(支票) 1383.3.5 EVNT005–事件數(shù)目測試(表外帳戶) 1393.3.6 EVNT006–事件數(shù)目測試(內(nèi)部賬戶) 1413.3.7 EVNT007–特定賬戶事件測試 1423.4 LOCATION地理位置主題域測試案例(GEOG) 1433.4.1 GEOG001–地理位置測試 143數(shù)據(jù)抽取及加載的測試案例AI（內(nèi)部核算）子系統(tǒng)測試案例案例編號：AI-01F

測試目的：察看內(nèi)部核算子系統(tǒng)RIT數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.RIT

38332selectsum(RITBASRAT)fromsysa.RIT

22942.225013selectsum(RITUP)fromsysa.RIT

2.437504selectsum(RITDW)fromsysa.RIT

0.00000

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_ai_minr_rit;

38332selectsum(RITBASRAT)fromsysload.abis_ai_minr_rit;

22942.225013selectsum(RITUP)fromsysload.abis_ai_minr_rit;

2.437504selectsum(RITDW)fromsysload.abis_ai_minr_rit;

0.00000備注：

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：AI-02F

測試目的：察看內(nèi)部核算子系統(tǒng)PRN數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.PRN

174212selectsum(PRNRIT)fromsysa.PRN74355.287743selectsum(PRNINT_AMT)fromsysa.PRN

45555486.424selectsum(PRNOVERINT)fromsysa.PRN

0.000005selectsum(PRNOVERAMT)fromsysa.PRN

0.006selectsum(PRNRVSRIT)fromsysa.PRN208.367007selectsum(PRNRVSINT)fromsysa.PRN755653683.71

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_ai_acct_prn;

17239+182(uv)2selectsum(PRNRIT)fromsysload.abis_ai_acct_prn;

74355.287743selectsum(PRNINT_AMT)fromsysload.abis_ai_acct_prn;

45555486.424selectsum(PRNOVERINT)fromsysload.abis_ai_acct_prn;

0.000005selectsum(PRNOVERAMT)fromsysload.abis_ai_acct_prn;

0.006selectsum(PRNRVSRIT)fromsysload.abis_ai_acct_prn;

208.27600+0.09100(uv)7selectsum(PRNRVSINT)fromsysload.abis_ai_acct_prn;

755448643.71+205040.00(uv)備注：

增加PRNPAC_NO&PRNRAC_NO以保證全部數(shù)據(jù)記錄被加載入數(shù)據(jù)庫。

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：AI-02D

測試目的：察看內(nèi)部核算子系統(tǒng)PRN數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.PRNwherePRNAC_DAT=’20031202’129982selectsum(PRNRIT)fromsysa.PRNwherePRNAC_DAT=’20031202’51766.217603selectsum(PRNINT_AMT)fromsysa.PRNwherePRNAC_DAT=’20031202’2782512.464selectsum(PRNOVERINT)fromsysa.PRNwherePRNAC_DAT=’20031202’0.000005selectsum(PRNOVERAMT)fromsysa.PRNwherePRNAC_DAT=’20031202’0.006selectsum(PRNRVSRIT)fromsysa.PRNwherePRNAC_DAT=’20031202’1.838007selectsum(PRNRVSINT)fromsysa.PRNwherePRNAC_DAT=’20031202’104293540.00

測試語句(Teradata)1selectcount(*)fromsysload.abis_ai_acct_prn;12926+72(uv)2selectsum(PRNRIT)fromsysload.abis_ai_acct_prn;51766.217603selectsum(PRNINT_AMT)fromsysload.abis_ai_acct_prn;2782512.464selectsum(PRNOVERINT)fromsysload.abis_ai_acct_prn;0.000005selectsum(PRNOVERAMT)fromsysload.abis_ai_acct_prn;0.006selectsum(PRNRVSRIT)fromsysload.abis_ai_acct_prn;1.80200+0.036(uv)7selectsum(PRNRVSINT)fromsysload.abis_ai_acct_prn;104029120.00+264420(uv)備注：增加PRNPAC_NO&PRNRAC_NO以保證全部數(shù)據(jù)記錄被加載入數(shù)據(jù)庫。

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：AI-03F

測試目的：察看內(nèi)部核算子系統(tǒng)IAC數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.IAC

40817502selectsum(IACRAT)fromsysa.IAC

8311.027813selectsum(IACOVD)fromsysa.IAC

9384.06784

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_ai_acct_iac;

40817502selectsum(IACRAT)fromsysload.abis_ai_acct_iac;

8311.027813selectsum(IACOVD)fromsysload.abis_ai_acct_iac;

9384.06784備注：

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：AI-04F

測試目的：察看內(nèi)部核算子系統(tǒng)IAC數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.IAC

40817502selectsum(IACDB_ACC)fromsysa.IAC

-36851939025103.583selectsum(IACDAA)fromsysa.IAC

8295912246933.054selectsum(IACCR_ACC)fromsysa.IAC

62936519188305.645selectsum(IACCDA)fromsysa.IAC

2015091295405.22

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_ai_acct_iacbal;

40817502selectsum(IACDB_ACC)fromsysload.abis_ai_acct_iacbal;

-36851939025103.583selectsum(IACDAA)fromsysload.abis_ai_acct_iacbal;

8295912246933.054selectsum(IACCR_ACC)fromsysload.abis_ai_acct_iacbal;

62936519188305.645selectsum(IACCDA)fromsysload.abis_ai_acct_iacbal;

2015091295405.22備注：

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：AI-05F

測試目的：察看內(nèi)部核算子系統(tǒng)GAD數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.GAD

161688582selectsum(GADDBTTMS)fromsysa.GAD

1588211473selectsum(GADDBTAMT)fromsysa.GAD

8080936309567.494selectsum(GADDBTBAL)fromsysa.GAD

106378072647512.365selectsum(GADCRDTMS)fromsysa.GAD

1628078256selectsum(GADCRDAMT)fromsysa.GAD

8101673846619.607selectsum(GADCRDBAL)fromsysa.GAD

121660032516164.06

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_ai_acct_gad;

161688582selectsum(GADDBTTMS)fromsysload.abis_ai_acct_gad;

1588211473selectsum(GADDBTAMT)fromsysload.abis_ai_acct_gad;

8080936309567.494selectsum(GADDBTBAL)fromsysload.abis_ai_acct_gad;

106378072647512.365selectsum(GADCRDTMS)fromsysload.abis_ai_acct_gad;

1628078256selectsum(GADCRDAMT)fromsysload.abis_ai_acct_gad;

8101673846619.607selectsum(GADCRDBAL)fromsysload.abis_ai_acct_gad;

121660032516164.06備注：

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：AI-05D

測試目的：察看內(nèi)部核算子系統(tǒng)GAD數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.GADwhereGADYEA=2003ANDGADMTH=12ANDGADDAT=21839182selectsum(GADDBTTMS)fromsysa.GADwhereGADYEA=2003ANDGADMTH=12ANDGADDAT=0220210293selectsum(GADDBTAMT)fromsysa.GADwhereGADYEA=2003ANDGADMTH=12ANDGADDAT=02109448228018.924selectsum(GADDBTBAL)fromsysa.GADwhereGADYEA=2003ANDGADMTH=12ANDGADDAT=021178494907734.535selectsum(GADCRDTMS)fromsysa.GADwhereGADYEA=2003ANDGADMTH=12ANDGADDAT=0219713476selectsum(GADCRDAMT)fromsysa.GADwhereGADYEA=2003ANDGADMTH=12ANDGADDAT=02109485930497.287selectsum(GADCRDBAL)fromsysa.GADwhereGADYEA=2003ANDGADMTH=12ANDGADDAT=021357183515855.29

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_ai_acct_gad;1839182selectsum(GADDBTTMS)fromsysload.abis_ai_acct_gad;20210293selectsum(GADDBTAMT)fromsysload.abis_ai_acct_gad;109448228018.924selectsum(GADDBTBAL)fromsysload.abis_ai_acct_gad;1178494907734.535selectsum(GADCRDTMS)fromsysload.abis_ai_acct_gad;19713476selectsum(GADCRDAMT)fromsysload.abis_ai_acct_gad;109485930497.287selectsum(GADCRDBAL)fromsysload.abis_ai_acct_gad;1357183515855.29備注：

YYYY=年份，MM=月份，XX=日

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：AI-06D

測試目的：察看內(nèi)部核算子系統(tǒng)CRT數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.CRTwhereCRTDAT='20031201'

26632selectsum(CRTAMT)fromsysa.CRTCRTwhereCRTDAT='20031201'

-3376512286.41

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_ai_evnt_crt;

26632selectsum(CRTAMT)fromsysload.abis_ai_evnt_crt;

-3376512286.41備注：

‘YYYYMMDD’為數(shù)據(jù)所屬日期。

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：AI-07F

測試目的：察看內(nèi)部核算子系統(tǒng)ERP數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.ERP

222selectsum(ERPCCYUNT)fromsysa.ERP

22003selectsum(ERPLSTEND)fromsysa.ERP

6686.203604selectsum(ERPCUREND)fromsysa.ERP

100.00000

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_ai_minr_erp;

222selectsum(ERPCCYUNT)fromsysload.abis_ai_minr_erp;

22003selectsum(ERPLSTEND)fromsysload.abis_ai_minr_erp;

6686.203604selectsum(ERPCUREND)fromsysload.abis_ai_minr_erp;

100.00000備注：

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：AI-08F

測試目的：察看內(nèi)部核算子系統(tǒng)CCY數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.CCY

48

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_ai_minr_ccy;

48備注：

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：AI-09F

測試目的：察看內(nèi)部核算子系統(tǒng)ITM數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.ITM

695

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_ai_acct_itm;

695備注：

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：AI-10D

測試目的：察看內(nèi)部核算子系統(tǒng)RVL數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.RVLwhereRVLRVSDAT='20031201'ORRVLOCUDAT='20031201'

18262selectsum(RVLAMT)fromsysa.RVLwhereRVLRVSDAT='20031201'ORRVLOCUDAT='20031201'

-105989533.89

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_ai_acct_rvl;

18262selectsum(RVLAMT)fromsysload.abis_ai_acct_rvl;

-105989533.89備注：

‘20031201’為數(shù)據(jù)所屬日期。

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：AI-11D

測試目的：察看內(nèi)部核算子系統(tǒng)IAD數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.IADwhereIADAC_DAT='20031201'

2610482selectsum(IADAMT)fromsysa.IADwhereIADAC_DAT='20031201'

-3056668167.95

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_ai_evnt_iad;

260800+248(UV)2selectsum(IADAMT)fromsysload.abis_ai_evnt_iad;

-3055178766.25+-1489401.7(uv)備注：修改數(shù)據(jù)加載數(shù)據(jù)表為multi-set以保證全部數(shù)據(jù)記錄進入。

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：AI-12F

測試目的：察看內(nèi)部核算子系統(tǒng)ICT數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.ICT0

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_ai_acct_ict

0備注：

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：AI-13F

測試目的：察看內(nèi)部核算子系統(tǒng)ERH數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.ERH

02selectsum(ERHCCYUNT)fromsysa.ERHNULL3selectsum(ERHLSTEND)fromsysa.ERHNULL4selectsum(ERHCUREND)fromsysa.ERH

NULL

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_ai_minr_erh;

02selectsum(ERHCCYUNT)fromsysload.abis_ai_minr_erh;

NULL3selectsum(ERHLSTEND)fromsysload.abis_ai_minr_erh;

NULL4selectsum(ERHCUREND)fromsysload.abis_ai_minr_erh;

NULL備注：

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：AI-13D

測試目的：察看內(nèi)部核算子系統(tǒng)ERH數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.ERHwhereERHEFFDAT=’20031202’02selectsum(ERHCCYUNT)fromsysa.ERHwhereERHEFFDAT=’20031202’

NULL3selectsum(ERHLSTEND)fromsysa.ERHwhereERHEFFDAT=’20031202’

NULL4selectsum(ERHCUREND)fromsysa.ERHwhereERHEFFDAT=’20031202’

NULL

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_ai_minr_erh;02selectsum(ERHCCYUNT)fromsysload.abis_ai_minr_erh;

NULL3selectsum(ERHLSTEND)fromsysload.abis_ai_minr_erh;

NULL4selectsum(ERHCUREND)fromsysload.abis_ai_minr_erh;

NULL備注：

‘YYYYMMDD’為數(shù)據(jù)所屬日期。

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

CC（信用卡）子系統(tǒng)測試案例案例編號：CC-01F

測試目的：察看信用卡CCM數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.CCM

5206072selectsum(CCMDBBAL)fromsysa.CCM

136901654.843selectsum(CCMCRBAL)fromsysa.CCM

1002303434.134selectsum(CCMFRZAMT)fromsysa.CCM

631588.555selectsum(CCMLMBAL)fromsysa.CCM

925375749.148selectsum(CCMGURAMT)fromsysa.CCM

10661148.229selectsum(CCMDEPAMT)fromsysa.CCM

0

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_cc_acct;

520604+3(uv)2selectsum(CCMDBBAL)fromsysload.abis_cc_acct;

136901654.843selectsum(CCMCRBAL)fromsysload.abis_cc_acct;

1002290850.584selectsum(CCMFRZBAL)fromsysload.abis_cc_acct;

631588.555selectsum(CCMLMBAL)fromsysload.abis_cc_acct;

925363132.70+12616.44(uv)8selectsum(CCMGURAMT)fromsysload.abis_cc_acct;10661148.229selectsum(CCMDEPAMT)fromsysload.abis_cc_acct;0.00備注：

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：CC-02F

測試目的：察看信用卡CCM數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.CCM

5206072selectsum(CCMDBBAL)fromsysa.CCM

136901654.843selectsum(CCMCRBAL)fromsysa.CCM

1002303434.134selectsum(CCMDEPAMT)fromsysa.CCM

0

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_cc_acct_bal;

5206072selectsum(CCMDBBAL)fromsysload.abis_cc_acct_bal;

136901654.843selectsum(CCMCRBAL)fromsysload.abis_cc_acct_bal;

1002303434.134selectsum(CCMDEPAMT)fromsysload.abis_cc_acct_bal;

0.00備注：

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：CC-03D

測試目的：察看信用卡CCD數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.CCDwhereCCDAC_DAT='20031201'

226342selectsum(CCDAMT)fromsysa.CCDwhereCCDAC_DAT='20031201'

-5076469.123selectsum(CCDVCHCLS)fromsysa.CCDwhereCCDAC_DAT='20031201'

132829

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_cc_evnt;

226342selectsum(CCDAMT)fromsysload.abis_cc_evnt;

-5076469.123selectsum(CCDVCHCLS)fromsysload.abis_cc_evnt;

132829備注：

‘YYYYMMDD’為數(shù)據(jù)所屬日期。

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：CC-04F

測試目的：察看信用卡CCI數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.CCI

7262selectsum(CCIUP_AMT)fromsysa.CCI

17997454.013selectsum(CCIDW_AMT)fromsysa.CCI

20771706.004selectsum(CCICSHLMT)fromsysa.CCI

5114552.005selectsum(CCICSMLMT)fromsysa.CCI

21052203.006selectsum(CCIZZLMT)fromsysa.CCI

2749611.007selectsum(CCIDFLMT)fromsysa.CCI

3142703.008selectsum(CCIRAFTIM)fromsysa.CCI

450

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_cc_minr_cci;

7262selectsum(CCIUP_AMT)fromsysload.abis_cc_minr_cci;

17997454.013selectsum(CCIDW_AMT)fromsysload.abis_cc_minr_cci;

20771706.004selectsum(CCICSHLMT)fromsysload.abis_cc_minr_cci;

5114552.005selectsum(CCICSMLMT)fromsysload.abis_cc_minr_cci;

21052203.006selectsum(CCIZZLMT)fromsysload.abis_cc_minr_cci;

2749611.007selectsum(CCIDFLMT)fromsysload.abis_cc_minr_cci;

3142703.008selectsum(CCIRAFTIM)fromsysload.abis_cc_minr_cci;

450備注：

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：CC-05F

測試目的：察看信用卡CCR數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.CCR

5601432selectsum(CCRSERIAL/1000000)fromsysa.CCR

171115713*1000000

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_cc_evnt_ccr;

5601432selectsum(CCRSERIAL/1000000)fromsysload.abis_cc_evnt_ccr;

171115713*1000000備注：

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：CC-06D

測試目的：察看信用卡CSR數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.CSRwhereCSRDAT='20031201'ORCSRVSDAT='20031201'

5042selectsum(CSRTR_AMT)fromsysa.CSRwhereCSRDAT='20031201'ORCSRVSDAT='20031201'

943294.05

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_cc_evnt_csr;

5042selectsum(CSRTR_AMT)fromsysload.abis_cc_evnt_csr;

943294.05備注：

‘YYYYMMDD’為數(shù)據(jù)所屬日期。

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：CC-07D

測試目的：察看信用卡CRL數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.CRLwhereCRLDAT='20031201'ORCRLCANDATE='20031201'

688

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_cc_evnt_crl;

688備注：

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：CC-08F

測試目的：察看信用卡CDT數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.CDT

556105

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_cc_card;

556105備注：

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：CC-08D

測試目的：察看信用卡CDT數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.CDTwhereCDTOPEDAT=’20031202’ORCDTDELDAT=’20031202’ORCDTREPDAT=’20031202’ORCDTCANDAT=’20031202’ORCDTPATDAT=’20031202’

1516

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_cc_card;

1516備注：

‘YYYYMMDD’為數(shù)據(jù)所屬日期。

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：CC-09F

測試目的：察看信用卡CCT數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.CCT

401

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_cc_card_cntr;

401備注：

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：CC-10F

測試目的：察看信用卡CID數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.CID

167882selectsum(CIDENRFUD)fromsysa.CID

7531023921.37

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_cc_party_org;

167882selectsum(CIDENRFUD)fromsysload.abis_cc_party_org;

7531023921.37備注：

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：CC-11F

測試目的：察看信用卡CPD數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.CPD

8752842selectsum(CPDWORNUM)fromsysa.CPD

17214723selectsum(CPDBSGZNX)fromsysa.CPD

26585584selectsum(CPDKPNUM)fromsysa.CPD

400279

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_cc_party_indv;

875282+2（uv）2selectsum(CPDWORNUM)fromsysload.abis_cc_party_indv;

17214723selectsum(CPDBSGZNX)fromsysload.abis_cc_party_indv;

26585584selectsum(CPDKPNUM)fromsysload.abis_cc_party_indv;

400277備注：

此案例測試對業(yè)務(wù)分析無意義，因此刪除這個測試。

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：CC-12F

測試目的：察看信用卡CST數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.CST

384462selectsum(CSTFEE)fromsysa.CST

48319.1593selectsum(CSTPOSAMT)fromsysa.CST

15936

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_cc_party_cst;

384462selectsum(CSTFEE)fromsysload.abis_cc_party_cst;

48319.1593selectsum(CSTPOSAMT)fromsysload.abis_cc_party_cst;

15936備注：

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：CC-12D

測試目的：察看信用卡CST數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.CSTwhereCSTSTRTDAT=’20031202’ORCSTWTHDAT=’20031202’52selectsum(CSTFEE)fromsysa.CSTwhereCSTSTRTDAT=’20031202’ORCSTWTHDAT=’20031202’6.2003selectsum(CSTPOSAMT)fromsysa.CSTwhereCSTSTRTDAT='YYYYMMDD'ORCSTWTHDAT='YYYYMMDD'6

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_cc_party_cst;52selectsum(CSTFEE)fromsysload.abis_cc_party_cst;6.2003selectsum(CSTPOSAMT)fromsysload.abis_cc_party_cst;6備注：

‘YYYYMMDD’為數(shù)據(jù)所屬日期。

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：CC-13F

測試目的：察看信用卡CPP數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.CPP

4646092selectsum(CPPINTACT)fromsysa.CPP

1366142284.183selectsum(CPPBQDJJF)fromsysa.CPP

-205233408.564selectsum(CPPBQJLJF)fromsysa.CPP

62688135.295selectsum(CPPBQDZJF)fromsysa.CPP

12047733.74

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_cc_acct_cpp;

4646092selectsum(CPPINTACT)fromsysload.abis_cc_acct_cpp;

1366142284.183selectsum(CPPBQDJJF)fromsysload.abis_cc_acct_cpp;

-205233408.564selectsum(CPPBQJLJF)fromsysload.abis_cc_acct_cpp;

62688135.295selectsum(CPPBQDZJF)fromsysload.abis_cc_acct_cpp;

12047733.74備注：

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：CC-13D

測試目的：察看信用卡CPP數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.CPPwhereCPPENDDAT=’20031202’02selectsum(CPPINTACT)fromsysa.CPPwhereCPPENDDAT=’20031202’NULL3selectsum(CPPBQDJJF)fromsysa.CPPwhereCPPENDDAT=’20031202’NULL4selectsum(CPPBQJLJF)fromsysa.CPPwhereCPPENDDAT=’20031202’NULL5selectsum(CPPBQDZJF)fromsysa.CPPwhereCPPENDDAT=’20031202’NULL

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_cc_acct_cpp;02selectsum(CPPINTACT)fromsysload.abis_cc_acct_cpp;NULL3selectsum(CPPBQDJJF)fromsysload.abis_cc_acct_cpp;NULL4selectsum(CPPBQJLJF)fromsysload.abis_cc_acct_cpp;NULL5selectsum(CPPBQDZJF)fromsysload.abis_cc_acct_cpp;NULL備注：

‘YYYYMMDD’為數(shù)據(jù)所屬日期。

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

CD（支票）子系統(tǒng)測試案例案例編號：CD-01F

測試目的：察看支票CDM數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.CDM

5540462selectsum(CDMAGRLMT)fromsysa.CDM

100107923071233selectsum(CDMFRZAMT)fromsysa.CDM

2373561408.614selectsum(CDMCSHLMT)fromsysa.CDMwherecdmcshlmt<10000000000447090216442.275selectsum(CDMAGRRAT)fromsysa.CDM

161999.4766selectsum(CDMOVFLMT)fromsysa.CDM

10539873515.10

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_cd_acct;

5540462selectsum(CDMAGRLMT)fromsysload.abis_cd_acct;

100107923071233selectsum(CDMFRZAMT)fromsysload.abis_cd_acctwherecdmcshlmt<10000000000;

2373561408.614selectsum(cast(CDMCSHLMTasfloat))fromsysload.abis_cd_acct;447090216442.275selectsum(CDMAGRRAT)fromsysload.abis_cd_acct;

161999.4766selectsum(CDMOVFLMT)fromsysload.abis_cd_acct;

10539873515.10備注：

‘YYYYMMDD’為數(shù)據(jù)所屬日期。

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：CD-02D

測試目的：察看支票CDM數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.CDMwhereCDMLSTACTD=’20031201’orCDMOPNDAT=’20031201’orCDMCLODAT=’20031201’

573812selectsum(CDMAC_BAL)fromsysa.CDM

46245718931.44

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_cd_acct_bal;

573812selectsum(CDMAC_BAL)fromsysload.abis_cd_acct_bal;

46245718931.44備注：

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：CD-03D

測試目的：察看支票CDD數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.CDDwhereCDDAC_DAT='20031201'

1611162selectsum(CDDAMT)fromsysa.CDDwhereCDDAC_DAT='20031201'

-49102119.82

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_cd_evnt_cdd;

1611162selectsum(CDDAMT)fromsysload.abis_cd_evnt_cdd;

-49102119.82備注：

‘YYYYMMDD’為數(shù)據(jù)所屬日期。

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：CD-04D

測試目的：察看支票CDF數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.CDFwhereCDFAC_DAT='20031201'

129192selectsum(CDFJRNNO/1000000)fromsysa.CDFwhereCDFAC_DAT='20031201'

11615679*10000003selectsum(CDFAMT)fromsysa.CDFwhereCDFAC_DAT='20031201'

-10726988.014selectsum(CDFVCHCLS)fromsysa.CDFwhereCDFAC_DAT='20031201'

88565selectsum(CDFVCHNO/1000000)fromsysa.CDFwhereCDFAC_DAT='20031201'

16786*1000000

測試語句(Teradata)結(jié)果1selectcount(*)fromsysload.abis_cd_evnt_cdf;

129192selectsum(CDFJRNNO/1000000)fromsysload.abis_cd_evnt_cdf;

11615679*10000003selectsum(CDFAMT)fromsysload.abis_cd_evnt_cdf;

-10726988.014selectsum(CDFVCHCLS)fromsysload.abis_cd_evnt_cdf;

88565selectsum(CDFVCHNO/1000000)fromsysload.abis_cd_evnt_cdf;

16786*1000000備注：

‘YYYYMMDD’為數(shù)據(jù)所屬日期。

期望結(jié)果：ABIS及Teradata兩方結(jié)果一致

案例編號：CD-05D

測試目的：察看支票CDI數(shù)據(jù)表在抽取及加載前后數(shù)據(jù)的一致性

測試語句(ABIS)結(jié)果1selectcount(*)fromsysa.CDIwhereCDITRDAT='20031201'

34772selectsum(CDITRJRN/1000000)fromsysa.CDIwhereCDITRDAT='20031201'

3132099*1000000

測試語句(Teradata)結(jié)果1selectcoun