This discussion is archived
2 Replies Latest reply: Nov 2, 2012 7:37 AM by 516595 RSS

ODI - performance issue while loading data from Oracle to Netezza

911461 Newbie
Currently Being Moderated
Hello Team

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.

Thanks
Manoj

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points