A cleanse asset contains options on a Definition tab, a Configuration tab, and a Merge tab.
Use the Definition tab options to enter a name for the asset, optionally enter a description for the asset, and select the folder in which to store the asset. Use the Configuration tab options to configure the standardization operations that a mapping will perform. Optionally, use the Merge tab options to merge data from two or more fields into a single field.
You configure the standardization operations as a sequence of steps that the mapping follows at run time.
Configuration tab options
Use the Configuration tab options to configure the type of cleansing operations that a mapping will perform on the input data. Each instance that you add identifies one or more input fields to which a mapping can apply the cleanse operations. You add instances to configure different cleansing operations for different input fields within a single asset.
The following image shows the cleanse asset options in the Configuration tab:
The Configuration tab includes the following options:
1Add Instance option.
Adds a cleanse instance to the asset. You can add one or more cleanse instances.
Define one or more input fields in each instance that you add.
2Instance panel.
Displays the cleanse instances that you add to the asset. You can edit or delete an instance.
Expand or collapse the instance panel to show or hide the instances that you add. You might collapse the instance panel when you configure a step in an instance, so that the step configuration options are easier to view.
3Add Step option.
Adds a step to the asset. A step describes a standardization operation that a mapping can apply to an input data field.
4Up and Down options.
Moves a step that you select up or down within the step sequence. The mapping performs standardization operations in the order that you specify.
5Step sequence.
Defines the order in which the mapping applies each step to the input field.
6Operation options.
Lists the main element in the operation that you define within the step. For example, if you use a dictionary in a step, the list displays the dictionary name.
7Test input fields.
Contains the test data that you enter for the instance that you select.
8Test output fields.
Contains the result of the test for the instance that you select. The asset displays an output field for each input field that you add to an instance.
9Import file option.
Imports data to the test panel.
10Step properties.
Displays the configurable properties that you use to define the step.
11Dictionary data.
Shows the contents of any dictionary that you select in the step.
Merge tab options
Use the Merge tab options to merge multiple input fields into a single output field. You can merge any combination of the fields to suit your data requirements.
The following image shows the options in the Merge tab:
The Merge tab includes the following options:
1Add Merged Output option.
Opens the merge configuration options. Use the options to identify the fields to merge.
2Merged outputs panel.
Lists the merged fields that the asset will create at run time. Also lists the input fields in each case and the instances to which the inputs belong. You can edit or delete a merged field. When you hover over the merged field, the Edit and Delete options appear.
3Test input fields.
Contains input data that you enter to verify the structure of the merged field that you select.
