Mappings

Back Next

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.

In the mapping, create a data object parameter.

Select

Allow parameter to be overridden at runtime

Use the parameter as the source object.

In the mapping task, on the

Sources

tab, select

Query

as the source type.

Enter a default custom query.

On the

Runtime Options

tab, provide the parameter file name and location.

In the parameter file, enter the values to use when the task runs.

If you want to change the query, update the parameter value in the parameter file.

Parameter files

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

Overriding source queries

Overriding source queries