To create an asset in Data Quality, click New. When you click New, Data Quality prompts you to select an asset type. When you select Cleanse, Data Quality opens a new cleanse asset.
The asset displays a Definition tab, a Configuration tab, and a Merge tab. Use the Definition tab to define the name and the location of the asset. Use the Configuration tab to configure the steps that the mapping will apply to the input data. Use the Merge tab to create new fields from on two or more fields across the instances.
Note: You can also open the Definition, Configuration, and Merge tabs when you open the asset from the Explore page.
1To create a cleanse asset, click New > Cleanse.
2On the Definition tab, enter a name for the cleanse asset.
3Optionally, enter a description.
4Select the location in which to save the cleanse asset.
5Optionally, select a data quality dimension to represent the type of data quality issue that you want the asset to examine.
The Asset References panel appears. The Asset References panel shows additional assets that are referenced by Data Quality assets to perform transformation tasks. When you create a new asset, there are no referenced assets.
7Optionally, add a tag to the cleanse asset. You can search for assets with a common tag on the Explore page.
8Select the Configuration tab.
Data Quality displays the configuration workspace for the cleanse asset. Data Quality also displays a validation message to indicate that the step configuration is incomplete.
When you create a cleanse asset, the Instance panel in the Configuration view displays a single default cleanse instance. By default, the instance contains a single input field. The input field name is the name of the asset. Optionally, you can add input fields and modify the default input field name and instance name.
9Optionally, add one or more cleanse instances. For information about how to add a cleanse instance to the asset, see Adding a cleanse instance to the asset.
10Add a step to each cleanse instance in the asset.
Select one of the following step types:
- Convert Case
- Remove Values
- Remove Spaces
- Replace Values
11Configure the properties on the step to create an operation that the mapping can apply to the data.
12Optionally, add one or more additional steps to each instance.
Configure the properties on each step that you add.
13Optionally, configure a merge operation for two or more input fields. For information about configuring the fields to merge, see Merging records.
14Save the asset.
After you configure the cleanse asset, test the asset with sample data.