We are in the process of evaluating Talend, as well as other ETL tools. One of the things we are trying to vet is hardware setup that will give us optimal job performance. Our ETLs will have Oracle sources and Oracle targets, possibly on different database servers. My understanding (and please correct me if I am wrong) is that if we leverage ELT components, the bulk of the work during execution of the job occurs on the two database servers. In this situation, where would Talend reside? Or is that irrelevant since the db servers are doing all of the work anyway? If we leverage ETL components, the bulk of the work during execution of the job occurs on the machine where Talend resides, correct? Does this mean Talend should be installed on its own dedicated server to optimize performance? Any response is greatly appreciated! If you can post your opinions, as well as links pointing to relevant documentation, that would be most helpful. Thank you!
... View more