Hi All,

This is my first post in this forum and I am a newbie with Pentaho.
I am setting up a data integration steps where I need to transfer 1 M rows from Postgresql to Oracle.
I found the bottleneck in SELECT query in Postgresql. Now, I am thinking to execute COPY command, get the data and input to Oracle.
Can any one give some idea how I can achieve this?