DSXchange

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

Did you tried inserting a transformer stage in between CFF and Oracle stages to manipulate the fields with Spaces ?

If the Mainframe file has spaces in a field it is not a null value unless you define it so.

Are you sure you have spaces in the mainframe file and not Low Values ?

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.