Download - m ODS Add Src Subj New
-
7/27/2019 m ODS Add Src Subj New
1/10
TestCaseID Test Case
1 If the actn_ind is null or not 'A'.
2
The actn_ind is null, but the src_org_id is
present.
3 The actn_ind is 'A' but the src_org_id is null.
4 The actn_id is 'A' and the src_org_id is not null.
5 If data_prvd_dt is not present.
6
If none of the socio economic indicators are
present
7 If the name and all the address fields are null
8
if the src_org_id is not present in the Src_Grp
table
9
If max(prtl_key) is not available in the Src_Subj
table.
10
If max(prtl_key) is present in the src_subj table
for the src_org_id and src_grp_key.
11
If nme_adr_key is not present in the src_subj
table for the src_org_id and the src_grp_key.
12
if nme_adr_key is present in the and if its equal
to th src_grp_trkg_nbr from the source.
13
If the nme_adr_key does not match the
src_grp_trkg_nbr from the source.
14 If the parameter file is not present
15The number of records read, deleted,rejectedshould be recorded.
16 Source File or table doesn't have any record
17 Read count in the process control table
18 Insert count in the process control table
19 Reject count in the process control table
-
7/27/2019 m ODS Add Src Subj New
2/10
Expected Output Actual Output
The record will not be selected for Addition into the
Src_Subj table.
The record will not be selected for Addition into the
Src_Subj table.
The record will not be selected for Addition into the
Src_Subj table.
The record will be selected for Addition into the
Src_Subj table.
The record will not be selected for Addition into the
Src_Subj table.An entry will be made in the error
table.
The record will not be selected for Addition into the
Src_Subj table.An entry will be made in the error
table.
The record will not be selected for Addition into the
Src_Subj table.An entry will be made in the error
table.
The record will not be selected for Addition into the
Src_Subj table.An entry will be made in the error
table.A row will be created in the src_subj and
src_subj_mtch_dtl tables.
Set the value from src_subj to prtl_Key
Update the src_subj table.
Update the src_subj table.
Create a record in src_subj and src_subj_mtch_dtl
table.
The session will fail
The number of records inserted/deleted/updated,
read, rejected will be entered in the processcontrol table for the particular row_cret_prcs_id.
Workflow completes successfully with no records
loaded
Has the total number of records read from the
source of the business flow of the mapping
Total number of records Inserted in the target of
the business flow of the mapping
Total number of records either not inserted or
updated in the target of the business flow of the
mapping
-
7/27/2019 m ODS Add Src Subj New
3/10
TestCase
REC_SEQ_NB
R
ACTN_C
D
DATA_PRVD
_DT SRC_ORG_ID GRPG_BASS_CD
1 28910 D 2/2/2004 1 13075
2 28924 2/2/2004 123 13075
3 28925 A 2/2/2004 130754 28931 A 10/10/2004 1234 13075
5 28909 A 34545 13075
6 28911 A 12/7/2004 90675 13075
7 28912 A 12/12/2003 299 13075
8 28912 A 12/12/2003 299 13075
9 28911 A 2/2/2002 1 13075
10 43757 A 12/24/2004 10101976 13075
51534 A 8/25/2004 23476 13075
SRC_ORG_ID SRC_GRP PRTL_KEY DATA_PRVD_D SUBJ_ORG_ID
23476 123 1/1/1900 2/2/2002 20
345458 A 8/25/2004 978768 13075
SRC_ORG_ID SRC_GRP PRTL_KEY DATA_PRVD_D SUBJ_ORG_ID978768 3454 1/1/1900 2/2/2002 20
345458 A 8/25/2004 978768 13075
SRC_ORG_ID SRC_GRP PRTL_KEY DATA_PRVD_D SUBJ_ORG_ID
78768 454 1/1/1900 2/2/2002 20
14 If the parameter file is not present, then the session will fail.
PRCS_RUN_ID PRCS_NMUSR_ID STRT_TMST END_TMST
4338 m_ODS_D powerctr 8/4/2004 12:42 8/4/2004 12:43
16 No Records in Source table with err_indc=0 and actn_cd='D'
17 Read =8
18 Inserted = 3
19 Rejected = 5
15
11
12
13
-
7/27/2019 m ODS Add Src Subj New
4/10
SRC_GRP_TRKG_NBR SUBJ_DUNS_NBR
LANG_
CD
SUBJ_OR
G_NME
STR_ADR
_LN_1_T
XT
STR_ADR
_LN_2_T
XT
ADR_TO
WN_NME
ADR_TER
R_ABRV_
NME
555555555 2 mainframe wwwwww wwwwww wwwwww wwwww
444444444 264313227 3 Dun and B aaaaaaaaa aaaaaaaaa aaaaaaaaa aaaaa
555555555 2 test data wwwwww wwwwww wwwwww wwwww555555555 2 Cognizant wwwwww wwwwww wwwwww wwwww
444444444 3 Techonolo aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
444444444 3
444444444 3 Chennai aaaaaaaaaaaaaaaaaawwwwww wwwww
444444444 238947456 3
444444444 9876534 3 Techonolo Cognizant test data Dun and B mainframe
348574756 34857486 3 Techonolo Cognizant test data Dun and B mainframe
9237489456 348957489 3 Dun and B aaaaaaaaa aaaaaaaaa aaaaaaaaa aaaaa
NME_ADR_KEY SUBJ_ORG_NME STR_A STR_ADR ADR_TO ADR_TER ADR_POS ADR_CTR
ghfyufdtycb jhguig hgyurjvo uhuiytojooj oiub yt7yfy ubg 970978 87675
9237489456 348957489 3 Dun and B aaaaaaaaa aaaaaaaaa aaaaaaaaa aaaaa
NME_ADR_KEY SUBJ_ORG_NME STR_A STR_ADR ADR_TO ADR_TER ADR_POS ADR_CTR9237489456 ghfyufdtycb jhguig hgyurjvo uhuiytojooj oiub yt7yfy ubg 970978 87675
1237489456 348957489 3 Dun and B aaaaaaaaa aaaaaaaaa aaaaaaaaa aaaaa
NME_ADR_KEY SUBJ_ORG_NME STR_A STR_ADR ADR_TO ADR_TER ADR_POS ADR_CTR
2337489456 ghfyufdtycb jhguig hgyurjvo uhuiytojooj oiub yt7yfy ubg 970978 87675
ROW_READ_CNT ROW_INSRT_CNT ROW_UROW_DE ROW_REJ_CNT
97 0 0 57 40
-
7/27/2019 m ODS Add Src Subj New
5/10
ADR_PO
ST_COD
E
ADR_CT
RY_CD
PHON_N
BR
ETHN_CL
SF_CD
CERT_NB
R
CERT_ST
RT_DT
CERT_EN
D_DT
AUDT_TR
L_EVNT_
CD
AUDT_TR
L_EVNT_
CMNT
wwwww 1 321 3 463647 2/2/2003 2/2/2006 1 eeeeeeeee
aaaaaaa 1 21 2 gggggg 2/2/2004 2/2/2005 1 aaaaaaaaa
wwwww 1 321 3 463647 2/2/2003 2/2/2006 1 eeeeeeeeewwwww 1 321 3 463647 2/2/2003 2/2/2006 1 eeeeeeeee
aaaaaaa 1 21 2 gggggg 2/2/2004 2/2/2005 1 aaaaaaaaa
1 2 345465 2/2/2004 2/2/2005 1 opweurehi
wwwww 1 234 2 345465 2/2/2004 2/2/2005 1 opweurehi
1 234 2 345465 2/2/2004 2/2/2005 1 opweurehi
2343 1 6589565 2 345465 2/2/2004 2/2/2005 1 opweurehi
2343 1 6589565 2 345465 2/2/2004 2/2/2005 1 opweurehi
aaaaaaa 1 21 2 gggggg 2/2/2004 2/2/2005 1 aaaaaaaaa
PHON_NB LANG_CD ROW_CR ROW_UPD_PRCS_ID
87754089 6 5954 6429
aaaaaaa 1 21 2 gggggg 2/2/2004 2/2/2005 1 aaaaaaaaa
PHON_NB LANG_CD ROW_CR ROW_UPD_PRCS_ID87754089 6 5954 6429
aaaaaaa 1 21 2 gggggg 2/2/2004 2/2/2005 1 aaaaaaaaa
PHON_NB LANG_CD ROW_CR ROW_UPD_PRCS_ID
87754089 6 5954 6429
-
7/27/2019 m ODS Add Src Subj New
6/10
WOM_O
WND_FL
G_TXT
WOM_BU
S_ENTP_
FLG_TXT
MINY_O
WND_FL
G_TXT
MINY_BU
S_ENTP_
FLG_TXT
VET_OW
ND_FLG_
TXT
VET_BUS
_ENTP_F
LG_TXT
DSBL_VE
T_BUS_E
NTP_FLG
_TXT
SVC_DSB
L_VET_F
LG_TXT
DSAV_VE
T_ENTP_
FLG_TXT
1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 11 1 1 1 1 1 1 1
aaa
1 1 1 1
1
1 1 1 1
1 1 1 1
1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1
-
7/27/2019 m ODS Add Src Subj New
7/10
DSAV_BU
S_ENTP_
FLG_TXT
SML_DSA
V_BUS_F
LG_TXT
HUBZON
E_FLG_T
XT
BUS_DVL
P_PGM_8
A_FLG_T
XT
NON_EN
G_SPK_F
LG_TXT
DSBL_O
WND_FL
G_TXT
HIST_UN
D_UTIL_B
US_FLG_
TXT
BLK_MIN
Y_COLG_
FLG_TXT
SPCL_CE
RT_LVL_
CD
1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 11 1 1 1 1 1 1 1 1
1
1
1
1
1
1
1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1
-
7/27/2019 m ODS Add Src Subj New
8/10
WAR_VE
T_TYP_C
D
FEIN_NB
R
SIC_1_C
ODE
SIC_2_C
ODE
SIC_3_C
ODE
SIC_4_C
ODE
SIC_5_C
ODE
SIC_6_C
ODE
NAICS_1_
CODE
1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 11 1 1 1 1 1 1 1 1
1 123 and cts tco dnb mwo 12 1
1
1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1
-
7/27/2019 m ODS Add Src Subj New
9/10
NAICS_2_
CODE
NAICS_3_
CODE
NAICS_4_
CODE
NAICS_5_
CODE
NAICS_6_
CODE
CTAC_N
ME
CTAC_TT
L_TXT FAX_NBR STRT_YR
1 1 1 1 1 1 wwwwww 2.22E+08 2005
1 1 1 1 1 1 aaaaaaa 22222 2002
1 1 1 1 1 1 wwwwww 2.22E+08 20051 1 1 1 1 1 wwwwww 2.22E+08 2005
2 3 3 33 3 8 wopereehr 22222 2002
5489678 2002
1 1 1 1 1 1 operthrihio 5489678 2002
1 1 1 1 1 1 operthrihio 5489678 2002
1 1 1 1 1 1 operthrihio 5489678 2002
1 1 1 1 1 1 operthrihio 5489678 2002
1 1 1 1 1 1 aaaaaaa 22222 2002
1 1 1 1 1 1 aaaaaaa 22222 2002
1 1 1 1 1 1 aaaaaaa 22222 2002
-
7/27/2019 m ODS Add Src Subj New
10/10
EMP_HR
E_CNT URL_ADR EML_ADR
ERR_IND
C
ROW_CR
ET_PRCS
_ID
ROW_UP
D_PRCS_
ID
max(PRTL_
KEY)
53 hhhhhhhhhhhhhhhhh 1 4779 4779
23 ddddddddddddddddd 0 4782 4782
53 hhhhhhhhhhhhhhhhh 0 4782 478253 hhhhhhhhhhhhhhhhh 0 4783 4783
23 ddddddddddddddddd 0 4779 4779
345 www.testd wopejriu@ 0 4779 4779
345 www.testd wopejriu@ 0 4779 4779
345 www.iorthireriotu@iwr 0 4783 4783
345 www.testd wopejriu@ 0 4779 4779
345 www.testd wopejriu@ 0 4779 4779 1
23 ddddddddddddddddd 0 4780 4780 1
23 ddddddddddddddddd 0 4780 4780 1
23 ddddddddddddddddd 0 4780 4780 1
http://www.testdata.com/mailto:[email protected]://www.testdata.com/mailto:[email protected]://www.iorthir.com/mailto:[email protected]://www.testdata.com/mailto:[email protected]://www.testdata.com/mailto:[email protected]:[email protected]://www.testdata.com/mailto:[email protected]://www.testdata.com/mailto:[email protected]://www.iorthir.com/mailto:[email protected]://www.testdata.com/mailto:[email protected]://www.testdata.com/