How to create a job with 2 different oracle DB connection in TALEND
Dear, I want to create a job which fetches a data from view(Different DB oracle connection) and uploads it to table(Different DB oracle connection). Could you please tell me which job i should use to have different DB connections in a 1 go. As i am new to TALEND tool , it would be grateful to get brief answer on above. Already thanks in advance!
Hi,
Here are tOracleDBXXX components
tOracleInput component reads a database and extracts fields based on a query.
tOracleOutput component writes, updates, makes changes or suppresses entries in a database.
Your work flow should be:tOralceInput(source DB)-->further transformation-->tOracleOutput(target DB)
The source DB and target DB can be different.
Best regards
Sabrina