AnsweredAssumed Answered

Push-down in RDBMSs

Question asked by Nicola Marangoni on May 30, 2018

Can PDI detect that all tables involved in a data integration step have the same JDBC connection and consequently convert the step in a single DML statement and handover its execution to the database engine?

 

Example: in a data integration step I select from 3-4 tables with joins and push the result to a target table in the same database. Can PDI generate a statement like this:

 

INSERT INTO

target_table

SELECT

source1

JOIN

source2

JOIN

....

?

Outcomes