Skip to Content

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

In Sap Bods

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 13 at 04:20 PM

    Hi,

    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.

    Add comment
    10|10000 characters needed characters exceeded