Teradata Connector

Back Next

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.

Administrator

, perform the following tasks in the Secure Agent properties:

Select the Secure Agent listed on the

Runtime Environments

tab, and click

Edit

In the Custom Configuration Details
section, select Data Integration Service
as the service and DTM
as the type.

Set

UseCustomSessionConfig

Yes

Data Integration

, perform the following steps in the

mapping

task:

In the

Runtime Options

page, navigate to

Advanced Session Properties

Select

Custom Properties

in the session property name list and enter the following value:

DisableTeradataCSForAggregator=Yes

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.