You can configure the task to push transformations, variables, functions, and operators to the database.
When you use
SQL ELT optimization
, the Secure Agent converts the expression in the transformation by determining equivalent operators, variables, and functions in the database. If there is no equivalent operator, variable, and function, the Secure Agent processes the transformation logic.