Teradata Connector > Teradata ODBC SQL ELT optimization > Enabling SQL ELT optimization for Expression and Aggregator transformations
  

Enabling SQL ELT optimization for Expression and Aggregator transformations

Before you enable SQL ELT optimization for a Teradata mapping task that includes Expression and Aggregator transformations in the mapping, you need to set certain properties for the Secure Agent and the task.
    1In Administrator, perform the following tasks in the Secure Agent properties:
    1. aSelect the Secure Agent listed on the Runtime Environments tab, and click Edit.
    2. bIn the Custom Configuration Details section, select Data Integration Service as the service and DTM as the type.
    3. cSet UseCustomSessionConfig to Yes.
      4. You can configure custom configuration details in the Secure Agent properties.
    2In Data Integration, perform the following steps in the mapping task:
    1. aIn the Runtime Options page, navigate to Advanced Session Properties.
    2. bSelect Custom Properties in the session property name list and enter the following value: DisableTeradataCSForAggregator=Yes
    You can configure advanced session properties on the schedule page.