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.

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



Joined: 02 Mar 2011

Posts: 163



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

Venki
Back to top
eganjp
Forum Addict
Forum Addict



Joined: 12 Sep 2007
ASUG Icon
Posts: 4280
Location: Denver Area


flag
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
aidelia_yahoo
Forum Member
Forum Member



Joined: 05 Jul 2013

Posts: 23


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

Jim,

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.

Regards,


Andrés
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.0270 seconds using 17 queries. (SQL 0.0027 Parse 0.0008 Other 0.0235)
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