Mappings

Back Next

SQL ELT optimization user-defined parameters

You can use an SQL ELT optimization user-defined parameter to perform SQL ELT optimization based on the parameter value defined in a parameter file. Use an SQL ELT optimization user-defined parameter when you want to perform different SQL ELT optimization options at different times.

For example, you might use source or target SQL ELT optimization during the peak hours of the day, but use full SQL ELT optimization from midnight until 2 a.m. when database activity is low.

To use the SQL ELT optimization user-defined parameter, perform the following steps:

Configure a parameter file to use the $$PushdownConfig user-defined parameter. Save the file to a directory local the Secure Agent to run the task.

Use the following format to define the parameter:

$$PushdownConfig=<SQL ELT optimization type>

For example:

$$PushdownConfig=Source

Configure a different parameter file of the same name for each SQL ELT type that you want to use.

In the task, add the SQL ELT Optimization property and select the $$PushdownConfig option.

Configure the task to use the parameter file.

Replace the parameter file version as needed.

SQL ELT optimization

Download Guide

Watch

Comments

Cloud Data Integration Homepage

0 COMMENTS

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

Rename Saved Search

Table of Contents

Mappings

Mappings

SQL ELT optimization user-defined parameters

SQL ELT optimization user-defined parameters