Question on partition method for lookup or Join stage

[longma98]

I have question on what to set for partition method for lookup or join stage.

If the main source is partitioned DB2 source, and I need to do lookups and join using separate stages, what partition method should I be using on the lookup/join stage? DB2, Auto, or Full?

The reason I am asking is that after reading through the parallel job menu, I am still not clear how PE handles lookup if the lookup data happens to be on a different partition.

Thanks

LM

[bigpoppa]

LM,

If I understand your question correctly, you want to know how to partition the non-DB2 data. You will want to use the DB2 partitioning method. I believe this will ensure that the partioning algorithm of your non-DB2 data matches that of the DB2 data.

The partitioning methods are described in the 'User Guide'.

-BP

[ray.wurlod]

Remember, too, that within DataStage PX environment, data can be re-partitioned "on the fly". There are pictures of this in the marketing material, but not in the manual.