Force Extract Transformation to be run on DBMS

Loko — Fri, 23 Nov 2018 15:20:04 GMT

Dear ALL,

How can I force a dbms run for an Extract Transofrmation ?

I have the input table on Oracle, the result of the extract generated in a library of type Oracle.

However the Extract seems not pushed on DBMS but rather run by SAS.

I have checked the Action - Check Database Processing and at the Details section it is written - Unable to completely process on Oracle.

At the Extract Transformation - Options - Additional Options - Use the optimized pass-through facility for SQL statements is set to Yes.

Any hints?

Thanks

Re: Force Extract Transformation to be run on DBMS

tomrvincent — Mon, 26 Nov 2018 15:55:49 GMT

Use explicit pass-thru rather than implicit.