Unanswered: How JDBC will afffect to the source server performance?
Our plan is using the PDI (via JDBC) for the ETL process. Our DataCenter team questioned whether the JDBC will affect to the performance of our database server (Oracle).
In this case, it's not the the transaction performance, but for example : how the JDBC server will hold the memory source a lot or not?
JDBC as the technology will not affect the performance. The queries that you send will affect the performance.
The JDBC driver implements the native Oracle protocol to talk to the database. There is no performance difference between the protocol implemented in the JDBC driver and a native OCI access (provided you use up-to-date drivers, the 11.2 should be your first choice, even when using 10.x)