ODI data transfer from SQL to Netezza-- Knowledge Modules recommended??
801667Sep 29 2010 — edited Sep 30 2010Hi,
My Source database is SQL and the target is Netezza.I used Netezzqa control append as IKM. I tried SQL to SQL and SQL to Jython on LKM side .But in both the cases Iam getting the below error.
com.sunopsis.sql.c : com.microsoft.sqlserver.jdbc.SQLServerDriver
Please advice the Knowledge modules which are suitable for the SQL to Netezza table to table data transfer with optimum processing time.