data copy from one table to another

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
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