Join Operator..Warning
Posted: Wed Sep 28, 2005 10:31 am
I am Joining two datasets in the Join Operator. The Join is an Inner Join on 4 Keys.. I am doing a Sort and Hash Partitioning in the Join Operator for both the Inout datasets..
I get the waring:
Join_26: When checking operator: User inserted sort "Join_26.TM_data_Sort" does not fulfill the sort requirements of the downstream operator "APT_JoinSubOperator in Join_26"
I figured that this was because i was not Including One of the Keys in the Sort and Hash Partitioning List on the Input tab's of the Join Operator.
The warning now has gone.Job has completed successfully.
I just want to make sure that this was the only Reason why the Warning Came up.
The Reasoning would be that u need to sort and Hash partition on all the Keys that u had Mentioned on which the Join Needs to be Performed.
If there is any other Reasoning, pl. let me know.
Thanks.
I get the waring:
Join_26: When checking operator: User inserted sort "Join_26.TM_data_Sort" does not fulfill the sort requirements of the downstream operator "APT_JoinSubOperator in Join_26"
I figured that this was because i was not Including One of the Keys in the Sort and Hash Partitioning List on the Input tab's of the Join Operator.
The warning now has gone.Job has completed successfully.
I just want to make sure that this was the only Reason why the Warning Came up.
The Reasoning would be that u need to sort and Hash partition on all the Keys that u had Mentioned on which the Join Needs to be Performed.
If there is any other Reasoning, pl. let me know.
Thanks.