BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Database Links Oracle Full pushdown


 
Search this topic... | Search DI: Performance and Tuning... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Author Message
vinaykp
Senior Member
Senior Member



Joined: 15 Jul 2010

Posts: 31



PostPosted: Thu Oct 15, 2015 12:56 pm 
Post subject: Database Links Oracle Full pushdown

Hello,

I am trying to get full pushdown for a DF where data is moved from table a(Database 1) to table b (database 2)( 1 to 1 mapping). Since they are on 2 different databases and 2 different servers, created a DB link to achieve pushdown.

Even after adding db link to the datastore, optimized SQL still doesn't do full pushdown.

Any one had this issue before.

ENVIRONMENT : Oracle11g
DS: 14.2.1.700
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0292 seconds using 17 queries. (SQL 0.0025 Parse 0.0008 Other 0.0258)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo