join stage where condition

developeretl · Post by **developeretl** » Tue Aug 03, 2010 12:38 am

Hi,
Iam using the db2 stages and i want to implement where logic in the join stage .... is it possible for me to specify where conditions in the join stage??? please guide me

nani0907 · Post by **nani0907** » Tue Aug 03, 2010 1:13 am

Where condition is not possible in Join stage.

ray.wurlod · Post by **ray.wurlod** » Tue Aug 03, 2010 3:05 am

Only implicitly. Within the Join stage you identify the "join keys" which would, in SQL, occur on either side of an "=" condition in a WHERE clause. But no other conditions are possible - it's a "pure" join.