Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(2 Ratings)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

HOW TO: Use In-out parameters in cloud mapping designer
Solution
In Summer'16 release, there is a new feature called in-out parameters. These are parameters that can retain the value and the value can be modified at the runtime of the mapping/task. The parameter can be used like any other parameter within the mapping. 
To create a new in-out parameter, create a mapping and on the right side, you see an option to view all parameters. This will have 2 sections one for input parameters and the other for in-out parameters. 
Create a new in-out parameter:

 ​

Select a type of value that you would need and set a default value too. 
Retention policy: When to retain the current value? (if the value is modified in the runtime, then current value is the modified value). If the task fails, then the current value will not be retained). 
Aggregation type: Determines how to update the value after the task changes the value. For instance, if the current value is 10, with aggregation type set to MAX then if the task modifies the value to any value higher than the current value, only then the value of the parameter gets updated. That is, it will be max(current_value,modified_value). If the newly modified value is less than 10, then the parameter value will remain unchanged because of MAX aggregation type and 10 current value. 

You can use the parameter like a normal value parameter in the task for expressions, filtering and so on.
To change the value of the in-out parameter, there are special functions to be used in the expression transformation as follows:
​SetVariable, SetMaxVariable, SetMinVariable, SetCountVariable

 

After the mapping is ready, deploy it to a mapping configuration task, there will be a tab named in-out parameters where you can view and modify properties of the parameters, including perform actions like resetting the value of the parameter to default and set a value for the parameter. 
After the task is run, on the activity log detail page for a task run, you can see the current value of the parameter, after the job is completed.
More Information
Reference
Applies To
Product: Cloud Data Integration
Problem Type:
User Type:
Project Phase:
Product Version:
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:6/15/2016 2:25 AMID:497375
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)