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
Question on partition method for lookup or Join stage
Moderators: chulett, rschirm, roy
Db2 Part
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: