Taskflows

Back Next

Example: Overriding parameters with a Data Task step

You want to override the following input parameters in a

mapping

task,

MyMT

The source data object parameter,

MySourceObject

, with default value

input.txt

The source connection parameter,

MySourceConnection

, with default value

My File Connection

The target connection parameter,

MyTargetConnection

, with default value

My File Connection

The target data object parameter,

MyTargetObject

, with default value

output5.txt

MyMT

uses

My File Connection

to read from the

input.txt

file and

My File Connection

to write to the

output5.txt

file.

You want

MyMT

to use

My File Connection

read from the

input.txt

file and use table and then use

My File Connection

to write to another output file,

output10.txt

file.

To do this, perform the following steps to override the default value of

MyTargetObject

with a Data Task step:

Create a taskflow and add a Data Task step,

Data Task 1

Go to

Data Task 1

Data Task

and add the

mapping

task

MyMT

Go to

Data Task 1

Input Fields

Perform the following steps to add

MySourceConnection

to the

Input Fields

section of

Data Task 1

Click the

Add

icon, and then navigate to and select

MySourceConnection

Click

Edit

. The

Edit Value

dialog box opens.

In the field next to

Source

, select the

Content

In the field next to

Value

, select

My File Connection

Perform the following steps to add

MySourceObject

to the

Input Fields

section of

Data Task 1

Click the

Add

icon, and then navigate to and select

MySourceObject

Click

Edit

. The

Edit Value

dialog box opens.

In the field next to

Source

, select

Content

In the field next to

Value

, enter

input.txt

Perform the following steps to add

MyTargetConnection

to the

Input Fields

section of

Data Task 1

Click the

Add

icon, and then navigate to and select

MyTargetConnection

Click

Edit

. The

Edit Value

dialog box opens.

In the field next to

Source

, select

Content

In the field next to

Value

, select

My File Connection

Perform the following steps to add

MyTargetObject

to the

Input Fields

section of

Data Task 1

Click the

Add

icon, and then navigate to and select

MyTargetObject

Click

Edit

. The

Edit Value

dialog box opens.

In the field next to

Source

, select

Content

In the field next to

Value

, enter

output10.txt

The following image shows the

Input Fields

of Data Task 1:

You have overridden the target data object parameter,

MyTargetObject

from the default value

output5.txt

output10.txt

You only need to add parameters that you want to override to the Input Fields section. In this example, you only override

MyTargetObject

. However, you have the option of overriding

MySourceObject

, and

MyTargetConnection

as well.

Parameters in taskflows

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

Taskflows

Taskflows

Example: Overriding parameters with a Data Task step

Example: Overriding parameters with a Data Task step