I have a different source database and target database, where I am trying to replicate the data from source to target without any transformations. I am trying to handle this using the ELT components, but I am only able to select one connection.
I am assuming that the ELT components can't handle multiple connections.
Please post your thoughts on how to handle this situation.
Could you please refer the below article which discuss in detail about ETL vs ELT?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema