Page 1 of 1

Problem with Hashed File settings

Posted: Thu Dec 22, 2005 11:29 am
by arsheshadri
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

Posted: Thu Dec 22, 2005 11:32 am
by ukyrvd
did u check the metadata on boths sides? like key clomuns.
BTW, what is the datatype for key column??

Posted: Thu Dec 22, 2005 11:39 am
by ameyvaidya
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. :wink:

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

Posted: Wed Dec 28, 2005 6:57 am
by arsheshadri
Thanks guys..there was problem with Key columns and the rows were not matching..Now it is working.

Cheers,
Sheshadri