Author |
Message |
ursfriend77 Principal Member


Joined: 02 Mar 2011
        Posts: 163

|
Posted: 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


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

|
Posted: 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


Joined: 05 Jul 2013
      Posts: 23

|
Posted: 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 |
|
 |
|