This subsection explains the Data Transformation Definition window for defining data transformation.
For the operation method, see 1.12 Operations in the Data transformation definition Window.
Figure 1-27 FigureData Transformation (Mapping) Definition window
Map nodes in the source schema tree viewer to nodes in the target schema tree viewer. In the mapping viewer, you can deploy functions selected from the palette, and connect node adapters and functions with mapping lines.
The items in the source schema tree viewer, the mapping viewer, and the target schema tree viewer are shown in the following figure and explained below.
Figure 1-28 FigureSource schema tree viewer, mapping viewer, and target schema tree viewer
From the tools on the palette, select the functions to be deployed in the mapping viewer. Also select mapping lines to connect node adapters and functions.
The items on the palette are shown in the following figure and explained below.
Figure 1-29 FigurePalette (Data Transformation Definition window)
The following table lists the groups and tools on the palette.
Table 1-7 TableGroups and tools on the palette (Data Transformation Definition window)
Icon | Display name | Explanation |
---|---|---|
![]() | Select node | Selects functions and mapping lines in the mapping viewer. |
![]() | Marquee | Selects the functions and mapping lines contained inside the rectangular frame. |
![]() | Mapping | Mapping lines for connecting nodes and functions. |
![]() | Character string | Group made up of all string-related functions. |
![]() | concat | String-concatenating function. |
![]() | substr | Substring-acquiring function. |
![]() | length | String-length-acquiring function. |
![]() | contain | String-checking function. |
![]() | trim | Node-trimming function. |
![]() | Number | Group made up of all number-related functions. |
![]() | format | Number format conversion function. |
![]() | calc | Node operation function. |
![]() | round | Node-rounding function. |
![]() | sum | Node summing-up function. |
![]() | bit | Group made up of all bit-related functions |
![]() | not | NOT operation function |
![]() | bitop | Logical operation function |
![]() | shift | Shift operation function |
![]() | node | Group made up of all node-related functions. |
![]() | name | Node name-acquiring function. |
![]() | count | Node count-acquiring function. |
![]() | exist | Node-checking function. |
![]() | Control | Group made up of all functions that control mapping. |
![]() | loop | Node-looping function. |
![]() | choose | Node-choosing function. |
![]() | Other | Group made up of all functions that do not belong to any other group. |
![]() | replace | Change value function. |
![]() | radix | Radix conversion function |
![]() | custom | Custom function. |
![]() | const | Constant-setting function. |