Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

HOW TO: Parameterize field mapping in IICS
Solution
Follow the below steps to parameterize the mapping:

1.  Add an expression transformation
2. Rename all the Incoming fields in Bulk either with a Prefix or Suffix. This ensures to have same name as the Incoming fields during field mapping.
3. Add an expression of a dummy field and provide a value. This can be used if there is a static field with same value
4. In the Expression tab of the expression transformation click on “Allow additional fields and expressions during task creation” and create a new parameter by giving a name. This helps to create/map fields of your choice
exp_param.PNG
5.  At target transformation add 2 rules

a.       First to “Include All Fields”

b.       Exclude “Fields by Text or Pattern”> Provide the pattern you designed in the expression transformation either Fields or Prefix or Fields of Suffix.

tgt_incoming_param.PNG 



This setting helps to pull all fields excluding the fields with certain pattern.
6. 
Deploy the mapping to Mapping Configuration Task
7. At Mapping Configuration Task, on the “Input Parameters” tab of Mapping configuration Task one can find Parameterized option to add fields with a drop-down symbol 
8. Add a new field by hovering on the drop down as below
new_field_param.PNG

9.  Create the field type as Output field, provide any name as per your use case, enter the datatype and precision if required. Later configure the field by mapping the required field as below
field_mapp_param.PNG
10. Validate the mapping and run the job.
More Information
Reference
Applies To
Product: Cloud Data Integration
Problem Type: Configuration
User Type: Architect
Project Phase: Implement
Product Version:
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:7/17/2019 9:00 PMID:579455
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)