Skip to Content
author's profile photo Former Member
Former Member

Difference between SQL and Pushdown_SQL

Hi Experts,

Could you please explain how SQL and Pushdown_SQL differ from each other and its use case.(When to use which function)

Also if someone explain its background operation in database level/Process it will be appreciated.

Thanks,

Pradheep S

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Dec 15, 2015 at 06:58 AM

    Pushdown_sql() is basically used to optimize performance, DS Engine pushes down as many transform operations as possible to the source or target database and combines as many operations as possible into one request to the database

    Data Integrator Pushdown SQL Functionality

    Also refer to @Dirk Venken blog

    Let the database do the hard work! Better performance in SAP Data Services thanks to full SQL-Pushdown

    SQL() function is used in a script for DML operations and return a single value to the user

    Regards

    Arun Sasi

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 15, 2015 at 06:54 AM
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.