Hi, what is the optimal way to COPY data from one table to another table? Implementing like below: tOracleInput --(main)--> tMap --(main)--> tOracleOutput
Hi
For better performance, if all these two tables are in the same Oracle, ELT components are more helpful.
tOracleInput --(main)--> tMap --(main)--> tOracleOutput
I think tOracleOutputBulkExec is much better than tOracleOutput.
Regards,
Pedro