Reading the Hash file

rajeevm · Post by **rajeevm** » Mon May 14, 2007 2:23 pm

Hi All,

I am facing the problem with the hash file it says Abnormal termination of Transformer stage and its not reading the data from the hash file , as it is writing into the hash file.

What could be problem i don't understand

I need your helpto resolve this

Thanks for the input

rajeev

us1aslam1us · Post by **us1aslam1us** » Mon May 14, 2007 2:33 pm

What is your design and what are the log messages in the director?

rajeevm · Post by **rajeevm** » Mon May 14, 2007 2:43 pm

Hi ,
Thanks for the reply

here is my job design :

ODBC STAGE(SOURCE FILE) -------> HASH FILE-------------->TRANSFORMER STAGE----------->ODBC STAGE(TARGET)

AND I HAVE ONE LOOK UP ODBC STAGE

I am getting everytime some weird warning

when i ran for the first time i got abnormal termination of stage and second time when i ran i got The system cannot move the file to a different disk drive.

Thanks again for the input

us1aslam1us · Post by **us1aslam1us** » Mon May 14, 2007 2:46 pm

Have you checked the Data Path of the Hashed file? Verify the input and output tabs on the hash file stage.

rajeevm · Post by **rajeevm** » Mon May 14, 2007 7:20 pm

I have checked the data path and also the input and outputs everything is fine but still i am getting the same warning

Thanks

rafik2k · Post by **rafik2k** » Tue May 15, 2007 12:34 am

rajeevm wrote:Hi ,
Thanks for the reply

here is my job design :

ODBC STAGE(SOURCE FILE) -------> HASH FILE-------------->TRANSFORMER STAGE----------->ODBC STAGE(TARGET)

AND I HAVE ONE LOOK UP ODBC STAGE

I am getting everytime some weird warning

when i ran for the first time i got abnormal termination of stage and second time when i ran i got The system cannot move the file to a different disk drive.

Thanks again for the input

Here what is the purpose of using hash file stage?
As you mentioned that you have one lookup ODBC stage? are you creating hash for this? where you are performing lookup for same?

ray.wurlod · Post by **ray.wurlod** » Tue May 15, 2007 12:50 am

The hashed file may be being used to remove duplicates - though a DISTINCT keyword in the column derivation in the ODBC stage would have done just as well in this particular job design.

rajeevm · Post by **rajeevm** » Tue May 15, 2007 3:10 pm

hi ray

I did not understand you point what exactly you mean to say i know hash file is used to remove duplicates but i am getting different warnings

I am using distinct key word in the sql query and i am moving the same to the hash file is that the problem i am getting

Thanks

ray.wurlod · Post by **ray.wurlod** » Tue May 15, 2007 5:08 pm

What PRECISELY are the error messages? "Weird message" doesn't help diagnosis. Post the detail of the error messages.

swades · Post by **swades** » Tue May 15, 2007 5:26 pm

Hashed file