Comments and answers for "How can we find that our job is full push down or partially push down ?"https://answers.sap.com/questions/431271/how-can-we-find-that-our-job-is-full-push-down-or.html
The latest comments and answers for the question "How can we find that our job is full push down or partially push down ?"Comment by Prashant Sontakke on Prashant Sontakke's answerhttps://answers.sap.com/comments/441997/view.html
<p>Thank You So Much Ravi , its really so helpful for me.</p>Fri, 23 Feb 2018 10:19:29 GMTPrashant SontakkeAnswer by Ravi kiran Pagidihttps://answers.sap.com/answers/430462/view.html
<p>Hi,</p>
<p> </p>
<p>open dataflow and now click on Validation ----&gt; Display optimized SQL (see below image)</p>
<p> </p>
<p><img src="https://answers.sap.com/storage/attachments/109219-dsip.jpg"></p>
<p> </p>
<p>Now below screen appears, Full push down is when left side it has only one datastore and the SQL starts with &quot;INSERT INTO&quot; and Partial pushdown is when the SQL starts with &quot;SELECT&quot; and SELECT statement should be generated for all the logics/filters/joins used in the dataflow (see below image)</p>
<p> Full pushdown means SELECT and INSERT is performed in database.. partial push means select is performed and DS processes that data to the target. </p>
<p> </p>
<p><img src="https://answers.sap.com/storage/attachments/109221-full.jpg"></p>Tue, 13 Feb 2018 16:20:43 GMTRavi kiran Pagidi