Hash File to ODBC

[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

[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

[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.