Reading the Hash file
Moderators: chulett, rschirm, roy
Reading the Hash file
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
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
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
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
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
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
Here what is the purpose of using hash file stage?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
As you mentioned that you have one lookup ODBC stage? are you creating hash for this? where you are performing lookup for same?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: