Netezza Connector
Posted: Tue Jun 17, 2014 9:57 am
Hello Friends,
I am trying to load data from a sequential file after some data type conversions into a Netezza Table. The DataStage version is 9 and Netezza Version is 7.0.4.
Some of the smaller files are quickly loaded using the Netezza Connector Stage: Options: Table Action: Truncate and Write Mode: Insert using automatic Temporary Table. However quite expectedly, the larger files (> 1 gb) are taking long time to load. Hence I used Balanced Optimization to push all the processing to the Netezza target database. However there is no performance gain still. Hence I have decided to use bulk load (nzload) for the larger files.
Now, unlike the earlier Netezza Enterprise Stage I do not see any bulk load option in Netezza Connector Stage. Am I missing something. Is the only way for me now if to call nzload as a after job subroutine or in a script.
Thanks in advance!
I am trying to load data from a sequential file after some data type conversions into a Netezza Table. The DataStage version is 9 and Netezza Version is 7.0.4.
Some of the smaller files are quickly loaded using the Netezza Connector Stage: Options: Table Action: Truncate and Write Mode: Insert using automatic Temporary Table. However quite expectedly, the larger files (> 1 gb) are taking long time to load. Hence I used Balanced Optimization to push all the processing to the Netezza target database. However there is no performance gain still. Hence I have decided to use bulk load (nzload) for the larger files.
Now, unlike the earlier Netezza Enterprise Stage I do not see any bulk load option in Netezza Connector Stage. Am I missing something. Is the only way for me now if to call nzload as a after job subroutine or in a script.
Thanks in advance!