Versions Compared

Old Version 7

changes.mady.by.user Anand Vedam

Saved on

compared with

New Version 8

changes.mady.by.user Anand Vedam

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • In case you do not want to use the SPDO feature, set the value for the Pipeline Parameter ELT_DISABLE_SUBQUERY_PUSHDOWN to True or true or TRUE.

  • To enable the SPDO feature back:

    • Change the Pipeline Parameter value to False, false, or FALSE.
      Or

    • Delete the Pipeline Parameter (return to the default behavior).

Info

Subquery Pushdown Optimization essentially results in elimination/rewrite of subqueries from certain Snaps—ELT Sort, ELT Unique, ELT Transform, ELT Coalesce, ELT Case Expression, ELT Conditional Functions, and ELT Math Functions—and a pushdown/rewrite of the subqueries from the rest of the ELT Snaps. For more information on which upstream Snaps can push down subqueries into a given Snap, refer to the respective Snap document.