Hi ,
I am extracting from the mainframe file and dumping the data into the target table using the load option . All the fields are non nullable both in the source and the target . But due to the blank spaces in the source PX converts them to null and tries to insert them in the target . The job aborts due to this ... Any help on this please
Mydesign looks like this
CFF(No of readers =1)------->Oracle Stage (Write method =load)
Any help on this please ... I have tried to search in the forum.There are issue like this but they were not resolved or there were no workarounds available ,......
Extending to what Aruna said, try to decode the value of the column that is creating issue. See what the SEQ() / CHAR() value is and then make sure they are indeed spaces or low values
Oracle may be converting the spaces to nulls and not PX, if that's the case then you can set APT_ORACLE_PRESERVE_BLANKS to true to stop that from happening.
-craig
"You can never have too many knives" -- Logan Nine Fingers