Using Target Expressions
When importing data, you can apply target expressions to the mapped dimensions. Target expressions enable you to transform the source value read from the source to the target dimension values to be loaded to target application. These expressions can be used instead of member mappings for performing simple data transformations. For large data sets using import expressions, the transformation improves data load performance.
Supported target expression types:
- Copy Source Value
- Prefix
- Suffix
- Map
- Substring
- Replace
- Default
- Rtrim
- Ltrim
- Rpad
- Lpad
- Constant
- Round
The Round expression is only available for the Amount dimension.
- Conditional
- Split
- SQL
- Upper
- Lower
- Process Map
Note:
Except for the Round expression type, target expression types cannot be applied to an Amount dimension or the Attribute, Currency, and Skip rows.To assign a target expression:
-
From the Data Integration home page, click to the right of the integration, and then select Map Dimensions.
-
In the mappings grid, select the target value to which to add a target expression by clicking to the right of the dimension, and then selecting Edit Target Expression.
-
From the Edit Target Expression page, click Expression Type, and then select a target expression.
-
From the Edit Target Expression screen, click Expression Type, and then select a target expression.
-
Select all parameters associated with the target expression and click OK.
The parameters shown on the page depend on the expression type.
To remove a target expression type, click .