Page 1 of 1
literal difference between join & merge stages in PX
Posted: Thu Sep 15, 2005 12:17 am
by balaid
Hi Folks
Can any one help me what is the the literal difference between join & merge stages in PX..
Thank in advance....
Posted: Thu Sep 15, 2005 6:11 am
by kumar_s
Hi,
The major difference between join and merge is
In merge we can get reject for all the posibility but not in join.
Full outer join is possible in Join, but not in merge.
It is preferable to use join for huge set of data
regards
kumar
Posted: Thu Sep 15, 2005 3:55 pm
by ray.wurlod
Merge can have separate reject links for each separate reference input. Join has no reject link.
Lookup has only one, irrespective of the number of reference inputs.