Hash partition not working in Join stage
Posted: Wed Dec 03, 2008 1:30 am
Hi All,
I have a datastage job in which the i am fetching data from a Teradata Connector and second from Dataset.
I join the data using a join stage.
When I am partitioning the data using Hash/Sort method on both the input links, the join is not provioding the correct output.
But when I change the partition method to ENTIRE, the join stage works fine. I cant go for Entire partition as the Volume of data is supposed to be very huge.
Has anyone ever faced such issue before??? If so what can be the resolution as the workaround of ENTIRE does not seem good to me.
Please suggest.
Regards,
Amit
I have a datastage job in which the i am fetching data from a Teradata Connector and second from Dataset.
I join the data using a join stage.
When I am partitioning the data using Hash/Sort method on both the input links, the join is not provioding the correct output.
But when I change the partition method to ENTIRE, the join stage works fine. I cant go for Entire partition as the Volume of data is supposed to be very huge.
Has anyone ever faced such issue before??? If so what can be the resolution as the workaround of ENTIRE does not seem good to me.
Please suggest.
Regards,
Amit