Problem with Hashed File settings

arsheshadri · Post by **arsheshadri** » Thu Dec 22, 2005 11:29 am

Hi,

I am using Hashed file for refering my rdbms table which is having 3 rows.
When I run the Job, the Input link for the Hashed file stage shows as 3 rows,0 rows/sec but the Output link shows as 0 rows,0 rows/sec.

When I checked the Output property of this Hashed File stage and clicked on View data, I am able to view all the 3 rows of the table.

Can some one suggest me whether I have done any wrong settings?

Thanks in Advance
Sheshadri

ukyrvd · Post by **ukyrvd** » Thu Dec 22, 2005 11:32 am

did u check the metadata on boths sides? like key clomuns.
BTW, what is the datatype for key column??

ameyvaidya · Post by **ameyvaidya** » Thu Dec 22, 2005 11:39 am

This happens when there is no matching row found in the hashed file for any input stream row. No row was fetched from the Hashed file for your run.

Nothing wrong in that.

Except if that is not what was expected (Rows should have matched!!!).

arsheshadri · Post by **arsheshadri** » Wed Dec 28, 2005 6:57 am

Thanks guys..there was problem with Key columns and the rows were not matching..Now it is working.

Cheers,
Sheshadri