xformer partition
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 236
- Joined: Sun Apr 01, 2007 7:41 am
- Location: Michigan
xformer partition
When i put same partition in xformer theres a warning saying only entire is allowed? Why is this warning coming? cant i put same partiton in transformer. And as well what partition i have to use for lookup reference link and input link. Should i use entire partition for reference links.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Post the exact error message. Any partitioning is permitted on the input to a Transformer stage, subject to the Preserve Partitioning flag of the stage upstream from it.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 23
- Joined: Sat Sep 29, 2007 6:05 am
- Location: Datastage
- Contact:
Partition
Hai
Same partition can't be used in transformer bcos if u r using the hash/entire/any other partition before transformer or any other stage, if u want to continue the hash partition for the remaining part of u r job, then go for the same partition.
for lookup better to use entire partition & for transformer hash partition is better to use.
Same partition can't be used in transformer bcos if u r using the hash/entire/any other partition before transformer or any other stage, if u want to continue the hash partition for the remaining part of u r job, then go for the same partition.
for lookup better to use entire partition & for transformer hash partition is better to use.
Murali
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can NOT make such sweeping generalizations. If the next stage downstream of a Transformer stage is a DB2/UDB Enterprise stage loading a partitioned table, for example, then probably the best partitioning algorithm for the Transformer stage (and, if possible, any upstream stages) is DB2.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.