SAS^® Data Integration Studio 4.905 does not observe any Oracle hints (or ORHINTS) for an input table that uses the Table Loader transformation with an SQL query:

However, the code generator does observe the ORHINTS option for the output table:

The relevant code in the log file looks like the following:

However, the code should look like the following:

In the automatically created code, the ORHINTS option is properly assigned to the macro variable %etls_tableOptions. However, the option is not used in the INSERT statement:

The only workaround is to select User written body for the Code generation mode setting of the Table Loader properties for the transformation:

Then append (&etls_tableOptions) to from &etls_lastTable within the INSERT statement.

Operating System and Release Information