Warning message in Merge stage ?

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
bhargav_dd
Premium Member
Premium Member
Posts: 57
Joined: Tue Jun 30, 2009 9:38 am

Warning message in Merge stage ?

Post by bhargav_dd »

Hi pals,
I am trying to do look up for masterdataset & update set (Both seq files) AND gave a reject link (peek )to merge.

M_DATA:
S_ID,FNAME,LNAME
1,MAHESH,VUPPALA
2,AVINASH,YEDULLA
3,VAMSHI,ANIMALLA
4,PRADEEP,VEJ
5,mark,john
7,A,B

uPDATE_DATA:
S_ID,MARKS,GRADE
1,90,A
2,75,B
3,60,C
4,40,D
7,50,E
6,30,F


OUTPUT :

"1","MAHESH","VUPPALA" ;,90,"A"
"2","AVINASH","YEDULLA&quo t;,75,"B"
"3","VAMSHI","ANIMALLA&quo t;,60,"C"
"4","PRADEEP","VEJ",4 0,"D"
"5","mark","john",0,& quot;"
"7","A","B",50," E"
Rejected row:
Peek_7,0: S_ID:6 MARKS:30 GRADE:F

error showed:
Merge_0,0: Master record (4) has no updates
Merge_0,0: Update record (4) of data set 1 rejected (no master record)

Is this relates to options in merge :
warn on reject updates &unmatched masters ..false


Please clarify this issue
thanks..
asorrell
Posts: 1707
Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas

Post by asorrell »

Merge_0,0: Master record (4) has no updates
- This means that the "5,mark,john" master record didn't have any updates

Merge_0,0: Update record (4) of data set 1 rejected (no master record)
- This means that the "6,30,F" update record didn't find any master record with an id of "6"
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2020
Post Reply