I am not happy with the performance while loading data from Oracle to Netezza.
Currently I am using LKM SQL to SQL for Source to Staging ( both Oracle) and
IKM Netezza Control Append for Staging(Oracle) to Target (Netezza).
Is there a better KM for doing this ?
I want to improve the performance as going forward I have to processs
millions of rows.
Any time you use SQL to SQL you will be transferring data in batches and it would be slow.
Consider using a different BULK load unload KM instead
Or you can tweak with JDBC parameters to see which gives you a better performance.