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!
Re: How to create a job with 2 different oracle DB connection in TALEND
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
-- Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.