Question on partition method for lookup or Join stage
Posted: Mon Sep 08, 2003 9:07 am
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
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