Problem
Netezza exports fail if a column in that export has a value of "null'" and the batch size is more than 1. In this scenario, the completed batch is dropped.
Cause
The batch is dropped due to Netezza semantics.
Solution
To solve this problem, you can either:
- Perform data preparation in the workbook and transform the null' value into a different value. The value is transformed before exporting into Netezza.
- Use a batch size of 1, however this might cause slow performance for export jobs.
Comments
0 comments
Please sign in to leave a comment.