DSXchange

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.

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

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.

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