I think Hash partitioning is best to use with join stage,aggregator stage and change capture stage
and entire for lukup[reference link]
any opinions....
The best is (Auto) in general. For a large reference table into a Lookup stage you may get some benefit from hash partitioning both the stream and the reference input based upon the lookup key.
Any stage that requires key adjacency (the previous poster mentioned some of them) requires partitioning on the join/grouping/remdup key using a key-based partitioning algorithm. Modulus is more efficient than hash, but is only available for a single-column integer key.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Partitioning depends on the business logic u apply in ur project
So what I think is rather than allowing DS to select the partitioning technique it will be useful if we mention the partitioning technique for different stages.
Hi,
I also have same impression as the partioning does not depend upon the business logic. But it has a big impact on the column data on which u mentioned the partion key.
Hope u got it....
Subrat
ramesh_inform wrote:Partitioning depends on the business logic u apply in ur project
So what I think is rather than allowing DS to select the partitioning technique it will be useful if we mention the partitioning technique for different stages.
What i believe is neither the stage nor business logic is as important as the Data itself is. The deeper you understand the data easier is to find partitioning technique.
subrat wrote:Hi,
I also have same impression as the partioning does not depend upon the business logic. But it has a big impact on the column data on which u mentioned the partion key.
Hope u got it....
Subrat
U hasn't posted in a white. Why do you hope U got it? As far as I can tell U never mentioned anything of the kind (U hasn't posted very often, so a search by author was quite short).
Incidentally, the second person personal pronoun in English is "you".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.