Page 1 of 1

In what scenario can we not use a hash file

Posted: Thu Sep 03, 2009 1:20 am
by n.parameswara.reddy@accen
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

Posted: Thu Sep 03, 2009 1:43 am
by miwinter
Interview question?

Define "primary data stream".

Posted: Thu Sep 03, 2009 2:41 am
by n.parameswara.reddy@accen
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"

Posted: Thu Sep 03, 2009 3:43 am
by miwinter
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.

Posted: Thu Sep 03, 2009 3:58 am
by laknar
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.

Posted: Thu Sep 03, 2009 5:40 am
by chulett
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.

Posted: Thu Sep 03, 2009 3:11 pm
by ray.wurlod
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