Hello, I'm having three identical databases in termes of structure (tables and columns), one for each country.
Example: the table customer exists in the three databases with same fields. Only the content is different because every country has its own client.
i want to load the three tables in on the single table in the destination, normally I would use three tOracleInput
Then add a value to indicate the country name in a tamp for each of the three and then concatenate all in a tUnite.
But since the three databases have the same exactly architecture,I want to do it in one single tOracle input and
execute the same sql statement "select code, nom from the customer" but on the three different databases.
i though about using context variable and tLoop but i am having problems to correctly design a functional job.
Solved! Go to Solution.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend
Test drive Talend's enterprise products.