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


2/10

Expected Output Actual Output

The record will not be selected for Addition into the

Src_Subj table.


Src_Subj table.


Src_Subj table.

The record will be selected for Addition into the

Src_Subj table.


Src_Subj table.An entry will be made in the error

table.



table.



table.



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


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


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


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


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


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


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


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


PHON_NB LANG_CD ROW_CR ROW_UPD_PRCS_ID

87754089 6 5954 6429


PHON_NB LANG_CD ROW_CR ROW_UPD_PRCS_ID87754089 6 5954 6429


PHON_NB LANG_CD ROW_CR ROW_UPD_PRCS_ID

87754089 6 5954 6429


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/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


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


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


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.iorthireriotu@iwr 0 4783 4783


345 www.testd wopejriu@ 0 4779 4779 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/

m ods add src subj new

Documents