Using Messages to Refine Your Transform
When you select a message in the messenger tab, the affected item is selected on the Model tab. You can use these features of the Transformation Editor to speed your design and deployment of your transforms.
To view messages
1. Open your transform.
2. Click Show Messages on the toolbar.
3. Select a message in the message tab.
Use the up and down arrow buttons to move up or down the error message list and change the focus in the Model tab.
4. Edit the selected item in the Model tab.
5. Save your transform.
Editing Parameters on the Parameters Tab
The Transformation Editor’s Parameters tab displays all of the parameters listed in the in and out containers from the Model tab.
The parameters displayed in the Transformation Editor conveys the cardinality of the parameters in the following ways:
• If the parameter is a sequence, square brackets are shown along with its name. For example, "a[ ]".
• If the max occurs of a sequence is non-zero, that number is displayed within the square brackets. For example, "a[45]".
• If the min occurs of a sequence is non-zero, that number is displayed as a the first part of a range. If max occurs is 0, the range has no upper bound and is displayed similar to "a[4-*]". If max occurs is specified, it is displayed similar to "a[4-45]".
The Parameters tab of the Transformation Editor can be useful as a single parameter editing tool across all of the operations in your transform. It can be more efficient, for example, to use the Parameters tab to change the data type of all TINYINT parameters to INT.
To edit parameters using the Parameters tab
1. Open your transform.
2. Select the Parameters tab.
The following graphic shows several parameters that exist for the in and out containers.
3. Select any row.
4. To add a new parameter, use the green plus button.
5. To adjust the order or position of the parameters use the arrow buttons.
6. Optionally, you can:
— Rename
— Change the data type
— Change the I/O direction
— Change Facets
7. Save your transform.
