In what scenario can we not use a hash file

n.parameswara.reddy@accen · Thu Sep 03, 2009 1:20 am

In what scenario can we not use a hash file
Hash files cannot be used to store data to provide a primary data stream. A data generating stage such as a Sequential File stage, or a database stage or ODBC stage can be used to generate a primary data stream

miwinter · Post by **miwinter** » Thu Sep 03, 2009 1:43 am

Interview question?

Define "primary data stream".

n.parameswara.reddy@accen · Thu Sep 03, 2009 2:41 am

miwinter wrote:Interview question?

Define "primary data stream".

i am new to server jobs , leave it "primary data stream"

Can you please give me In what scenario can you not use a hash file"

miwinter · Post by **miwinter** » Thu Sep 03, 2009 3:43 am

Still confused....

If you're trying to say that a hashed file can't be an input to a job, then that's false. As for scenarios when you couldn't use one, it's a rather too open-ended question/discussion, rather than a specific ask.

laknar · Post by **laknar** » Thu Sep 03, 2009 3:58 am

hashed file stage remove duplicate data based on key value.
there will be count mismatch on the data flow. we need to avoid the hashed file as source.

chulett · Post by **chulett** » Thu Sep 03, 2009 5:40 am

While the first statement is true about 'duplicates', the second is not necessarily true and the third is false.

Asking for a scenario when one cannot use a hashed file is a little broad, like asking when one couldn't use a screwdriver. Use the tool that's appropriate for the task, whether it's a screwdriver or a wrench or whatever.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 03, 2009 3:11 pm

A Hashed File is the mechanism by which database tables in the UniVerse database (and therefore in the DataStage Engine database) are implemented. You can do anything with a hashed file that you can do with any other database table stage, and a couple more things as well.

It's "hashed", not "hash".

Moderator: please move to server forum