literal difference between join & merge stages in PX

balaid · Post by **balaid** » Thu Sep 15, 2005 12:17 am

Hi Folks
Can any one help me what is the the literal difference between join & merge stages in PX..

Thank in advance....

kumar_s · Post by **kumar_s** » Thu Sep 15, 2005 6:11 am

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

ray.wurlod · Post by **ray.wurlod** » Thu Sep 15, 2005 3:55 pm

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.