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