Skip to Content

How can we find that our job is full push down or partially push down ?

Feb 13 at 10:04 AM


avatar image

In Sap Bods

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Ravi kiran Pagidi Feb 13 at 04:20 PM


open dataflow and now click on Validation ----> Display optimized SQL (see below image)

Now below screen appears, Full push down is when left side it has only one datastore and the SQL starts with "INSERT INTO" and Partial pushdown is when the SQL starts with "SELECT" and SELECT statement should be generated for all the logics/filters/joins used in the dataflow (see below image)

Full pushdown means SELECT and INSERT is performed in database.. partial push means select is performed and DS processes that data to the target.

dsip.jpg (43.9 kB)
full.jpg (20.6 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thank You So Much Ravi , its really so helpful for me.