Junk characters issue
Posted: Thu Jul 18, 2013 9:09 am
Hi Everyone,
We are having an issue while loading the data from source mainframe file to netezza database.
We are reading data in EBCDIC format and we are able to see the data in the view according to the requirement. However,when we try to load the data to netezza, it gave error as "bad rows limit exceeded".
When we checked the data in mainframe system manually, there are few special characters found in the file,however, while viewing the data through cff stage, they are not shown and data is displayed normally.
Could you please let me know how the cff stage reads junk data while transferring to its output tab and how to identify what are the exact special characters coming in.
We are having an issue while loading the data from source mainframe file to netezza database.
We are reading data in EBCDIC format and we are able to see the data in the view according to the requirement. However,when we try to load the data to netezza, it gave error as "bad rows limit exceeded".
When we checked the data in mainframe system manually, there are few special characters found in the file,however, while viewing the data through cff stage, they are not shown and data is displayed normally.
Could you please let me know how the cff stage reads junk data while transferring to its output tab and how to identify what are the exact special characters coming in.