DSXchange

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

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?

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.