One Star

data copy from one table to another

Hi, what is the optimal way to COPY data from one table to another table?
Implementing like below:
tOracleInput --(main)--> tMap --(main)--> tOracleOutput
1 REPLY
One Star

Re: data copy from one table to another

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