Problem with Hashed file

[stiwari]

Hello everyone,

I need help in hashed file.
I am taking input in hashed file from SQL server table and out put is going to the transformer where i am joining this hashed file with another SQL server table and finally loading the data to some another SQL sever table but when I run the Job i am not getting any value in out put link of hashed file and it is taking the value in its input link. So i am not able to get the values based on that joining condition.

Thanks in advance.....

[y_suresh]

HI Stiwari,

DId u check the output link properties of hash file and gave the same name as it is loading in input link and make sure u have same column line up in both the links , inout and out put....

Suresh

Hello everyone,

I need help in hashed file.
I am taking input in hashed file from SQL server table and out put is going to the transformer where i am joining this hashed file with another SQL server table and finally loading the data to some another SQL sever table but when I run the Job i am not getting any value in out put link of hashed file and it is taking the value in its input link. So i am not able to get the values based on that joining condition.

Thanks in advance.....

[stiwari]

Ya Suresh, I have given same file name for both even i am able to see the data in the output tab of hashed file when I press view data. but the value are not passing to the transformer.

Sumit..

[ArndW]

Does that mean when you run the job the director monitor shows no rows going down that link? Or how are you determining this?

[thurmy34]

Stiwari

Do you check the format of the column?
Maybe you lose some 0 in numeric column.

Hope this help.

[stiwari]

Suresh, It is showing 0 rows read from output link.....

[stiwari]

Thanks Thurmy34, it is working i have used trim function in the joining condition.......