DSXchange

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

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

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

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

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

Thanks

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?

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.

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

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

Hashed file