Hi,
i have a job in which i m using join stage,and source of the join stages are one dataset and one db2 api.Here i m performing inner join basced on key column.
On the dataset link i have used same partitioning and on db2 link i have used hash.Job is running fine,but i m getting worning in log about Tshort operator.so can anyone help me to handle that warning??
and can anyone tell me what is the meaning on prpogate,clear and set options in advance tab..??
Tshort operator
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I think tshort is the toothless version of the tsort operator.
DataStage is inserting tsort operators (and alerting you to the fact that it's doing so) because sorting is required on the input links to the Join stage and your design does not provide explicit sorting on those links (so DataStage assumes the data to be unsorted).
You can prevent this behaviour by adding Sort stages on the links, even if their sort mode is "don't sort, already sorted".
DataStage is inserting tsort operators (and alerting you to the fact that it's doing so) because sorting is required on the input links to the Join stage and your design does not provide explicit sorting on those links (so DataStage assumes the data to be unsorted).
You can prevent this behaviour by adding Sort stages on the links, even if their sort mode is "don't sort, already sorted".
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.