In Server job the stream going to the hashed file will have constraint reflink.NOTFOUND and for the reject it will be NOT(reflink.NOTFOUND) .
Is this correct...?
In PX the constraint for reflink.NOTFOUND = IsNOTNULL(input_colName)
and Reject link = IsNull(Input_Col_Name)
Also, how do i interpret server NOT(reflink.NOTFOUND) in PX...?
Interpretation in PX b/w Lnk.NOTFOUND and NOT(Lnk.NOTFOUND)
Moderators: chulett, rschirm, roy
Interpretation in PX b/w Lnk.NOTFOUND and NOT(Lnk.NOTFOUND)
Thanks in advance,
u dont have not found option in PX so
u have to use lookup+transformer stage.
in lookup stage have lookup failure constrints in properties tab to continue ..
take the both key column of primary and reference link to output..
And in the transformer have two o/p link applying constrints
isnotnull (referncelink. key) to get only the found records..
is null(referncelink. key) to get the not found records..
hope this might solve ur problem
u have to use lookup+transformer stage.
in lookup stage have lookup failure constrints in properties tab to continue ..
take the both key column of primary and reference link to output..
And in the transformer have two o/p link applying constrints
isnotnull (referncelink. key) to get only the found records..
is null(referncelink. key) to get the not found records..
hope this might solve ur problem
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Please refrain from using "u" for the second person pronoun - we have a Burmese user called U enrolled who - it appears - finds it offensive.
Given that the OP has also mentioned hashed files, it is opportune to ask whether this is a parallel job at all.
Given that the OP has also mentioned hashed files, it is opportune to ask whether this is a parallel job at all.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.