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

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

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

Push Down Operations

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
Principal Member
Principal Member

Joined: 02 Mar 2011

Posts: 165

PostPosted: Mon Aug 03, 2015 3:08 am 
Post subject: Push Down Operations

Hi Experts,

I am so confuse about push down Operations. how can we differentiate which one Full and which one is Partial pushdown to Improve Performance of Jobs?. Data_Transfer transformation is Full or Partial ?

Please explain me clearly, I have red lot of books and materials but still i am confusing.

Thanks for your help

Back to top
Forum Addict
Forum Addict

Joined: 12 Sep 2007
Posts: 4287
Location: Denver Area

PostPosted: Mon Aug 03, 2015 11:06 am 
Post subject: Re: Push Down Operations

The Data_Transfer transform will funnel all the data from the branch it is in to either a database table or a file, depending on how you have it configured.

The Query transform coded after the Data_Transfer may or may not push the entire SQL query down to the database. It depends on what you're doing.

The only way to tell for certain if everything is pushed down is to look at the Display Optimized SQL. It's been a while since I used a Data_Transfer transform so I don't remember if the Query transform coded downstream from the Data_Transfer will show up in the Display Optimized SQL.

If that isn't good enough then enable the trace flags such that all SQL commands are recorded in the trace log.

Jim Egan
ProKarma-an SAP Consulting Partner
Speaker at RMOUG Training Days 2013
Speaker at Sapphire Now 2013
Speaker at Business Objects User Conference 2013
-My ETL is faster than your database! - Advanced ETL performance tuning for Data Services
-Kill ETL bugs before they kill you!
My ETL blog

Latest Blog Posts
• 2014-04-17 Can Your ETL Make Your Reporting Faster?
• 2014-04-04 ProKarma Acquires Mantis Technology Group
• 2014-04-02 How to Create Charts in Webi (Part 2 of 2)
Back to top
Forum Member
Forum Member

Joined: 05 Jul 2013

Posts: 23

PostPosted: Fri Aug 28, 2015 12:23 pm 
Post subject: Re: Push Down Operations


DS definitively shows the queries after a DT. For example we use it a lot when we need to find surrogate keys in a big dimension for a relatively small set of data, not too small to prefer a NO_cache hint in the lookup transform.

But I also saw it being misused (in fact overuse) when some developers "believe" that is the solution to all the performance problems.


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.0281 seconds using 17 queries. (SQL 0.0030 Parse 0.0009 Other 0.0242)
CCBot/2.0 (
Hosted by | Terms of Service
phpBB Customizations by the
Shameless plug for Moments of Light Logo