Page 1 of 1

Hash File to ODBC

Posted: Wed Dec 15, 2004 4:05 pm
by pk46190
Hi
Guys
I am pretty new to DataStaging.I am facing a problem in my work.I am trying to load data from a Hash file(the data in it is transformed data as per the bussiness rules) to ODBC table(my target database is Oracle).I notice that not all the data in Hash file is loading into the ODBC.out of hundred records only two are loading into the ODBC.
I have tried all possibilities.
I would appreciate if someone could help me on this.Let me know what could the problem be.

Thanks
PK

Posted: Wed Dec 15, 2004 4:10 pm
by JDionne
We need the errors out of director. If you open Director, navigate to your job and right click you will see the option view log. there is where u will find the errors.
Jim

check your hash file

Posted: Wed Dec 15, 2004 5:47 pm
by changming
your hash file format is not right.
or
I met this problem beore. becasue I use composed key in hash file and one of the keys is null value. when you map the hash file to ODBC, the null value field will not be null value, it is something that datastage can not understand.