join in different environment

[dnat]

Hi

I have a job which joins a source and reference and it gives perfect results

When i run the same job in test environment, fetching the data from dev tables, it is not joining properly. I am wondering what could be the problem because the data is same

i am doing a sort and hash join in both the inputs of join.

[gssr]

Whats the difference between the job of both environment?
What is the unusual output you are getting in the test environment?

[dnat]

there is no difference, because i exported the job from dev and imported the same in test env.

The unusual output is, the key columns are joined properly in dev, but when i run with the same data in test(by pointing the DB to dev DB). it is not joining.

[ray.wurlod]

Tell us about the sorting and partitioning used in both environments.