SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Oracle partition options for DI transformations.

Accepted Solution Solved
Reply
User
Posts: 1
Accepted Solution

Oracle partition options for DI transformations.

[ Edited ]

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

 

 


Accepted Solutions
Solution
‎04-06-2018 09:19 AM
SAS Employee
Posts: 269

Re: Oracle partition options for DI transformations.

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 

View solution in original post


All Replies
Solution
‎04-06-2018 09:19 AM
SAS Employee
Posts: 269

Re: Oracle partition options for DI transformations.

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 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 279 views
  • 1 like
  • 2 in conversation