Regarding Hash File Usage

G SHIVARANJANI · Post by **G SHIVARANJANI** » Mon Feb 16, 2009 10:35 pm

Hi,

Can any one help me undeerstand, If a hash file can be used like a funnel stage in DS Parallal edition .

Thanks in Anticipation
Shivaranjani

ray.wurlod · Post by **ray.wurlod** » Tue Feb 17, 2009 1:25 am

No. It can't.

For starters, Hashed File stage is a passive stage whereas Funnel is (technically) an active stage.

And the correct terminology is HASHED file, not "hash" file.

I guess if you were really clever about generating guaranteed unique keys on all inputs and made sure that the data volume did not exceed what the hashed file is capable of storing (2GB with 32-bit addressing), and you didn't mind that the Hashed File stage will not open its output until all input links are closed, then you could mimic the functionality.

Apart from that, just remember the German soldier from Laugh In - "verrry interesting - but stupid!".

G SHIVARANJANI · Post by **G SHIVARANJANI** » Tue Feb 17, 2009 3:01 am

ray.wurlod wrote:No. It can't.

For starters, Hashed File stage is a passive stage whereas Funnel is (technically) an active stage.

And the correct terminology is HASHED file, not "hash" file.

I guess if yo ...

Hi Ray

Thanku,

But i have tried to send inputs from two sequential files (with same columns) to a hashed file which is later moved to another sequential file, I could see the records from the first two files are together coming as a result in the third squentioal file.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 17, 2009 3:30 am

Get a premium membership and read the rest of my response.

G SHIVARANJANI · Post by **G SHIVARANJANI** » Tue Feb 17, 2009 4:29 am

ray.wurlod wrote:Get a premium membership and read the rest of my response. ...

Ok