Oracle partition options for DI transformations.

[SoumyaD]

Hi,

I am having a problem in reading/writing/updating data from oracle partition when it is done on ORACLE pass through.

Please see the attached for details.

Could someone please help me with where I am going wrong?

Thanks,

Soumya

[JBailey · Accepted solution]

Hi @SoumyaD

When DI Studio generates explicit Pass-Through queries it filters-out SAS options targeted towards Implicit Pass-Through. The OR_PARTITION= data set option is one of these. There are some implicit pass-through options that can be passed to the database but I don't have a list of them. 

So, the take away is that OR_PARTITION= only applies to SAS implicit pass-through queries.

Best wishes,

Jeff