on 12-15-2015 5:40 AM
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
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
SQL() function is used in a script for DML operations and return a single value to the user
Regards
Arun Sasi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.