Table of Contents

Search

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

Mappings

Mappings

Overriding source queries

Overriding source queries

If you use a source query or filter condition in a mapping, you can override the value specified in the
mapping
task with values specified in a parameter file. You can override source queries for relational and ODBC database connections.
When you define an SQL query, the fields in the overridden query must be the same as the fields in the default query. The task fails if the query in the parameter file contains fewer fields or is invalid.
If a filter condition parameter is not resolved in the parameter file,
Data Integration
will use the parameter as the filter value and the task returns zero rows.
  1. In the mapping, create a data object parameter.
  2. Select
    Allow parameter to be overridden at runtime
    .
  3. Use the parameter as the source object.
  4. In the mapping task, on the
    Sources
    tab, select
    Query
    as the source type.
  5. Enter a default custom query.
  6. On the
    Schedule
    tab, provide the parameter file name and location.
  7. In the parameter file, enter the values to use when the task runs.
  8. If you want to change the query, update the parameter value in the parameter file.

0 COMMENTS

We’d like to hear from you!