difference between join , merge and lookup

Saama · Post by **Saama** » Wed Apr 18, 2007 3:58 pm

Hi,

Join supports all types of joins like inner join, outer join and full outer join.

what about merge and lookup.Does they support all types of join.

CanGurus help me out.

cheers;
Dileep

chulett · Post by **chulett** » Wed Apr 18, 2007 4:27 pm

If this is a Server question as you've marked the post, the first response you're going to get is "there is no Join or Lookup stage in Server jobs and Merge is for files". Actually, you just got it.

So is this actually a PX question?

ray.wurlod · Post by **ray.wurlod** » Wed Apr 18, 2007 4:38 pm

In server jobs the Merge stage supports all types of join, but only between two text files. You do, of course, require a key field (or more than one) on which to base the join condition.

As Craig noted, server jobs do not have a Join or a Lookup stage.