Table of Contents

Search

  1. Preface
  2. Mappings
  3. Parameters
  4. CLAIRE recommendations
  5. Data catalog discovery
  6. Visio templates

Mappings

Mappings

Pushdown optimization user-defined parameters

Pushdown optimization user-defined parameters

You can use a pushdown optimization user-defined parameter to perform pushdown optimization based on the parameter value defined in a parameter file. Use a pushdown optimization user-defined parameter when you want to perform different pushdown optimization options at different times.
For example, you might use source or target pushdown optimization during the peak hours of the day, but use full pushdown optimization from midnight until 2 a.m. when database activity is low.
To use the pushdown optimization user-defined parameter, perform the following steps:
  1. 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=<pushdown optimization type>
    For example:
    $$PushdownConfig=Source
    .
    Configure a different parameter file of the same name for each pushdown type that you want to use.
  2. In the task, add the Pushdown Optimization property and select the $$PushdownConfig option.
  3. Configure the task to use the parameter file.
  4. Replace the parameter file version as needed.