Cleanse assets

Back Next

Configuring a cleanse asset

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.

You can also open the Definition, Configuration, and Merge tabs when you open the asset from the Explore page.

To create a cleanse asset, click

New

Cleanse

On the

Definition

tab, enter a name for the cleanse asset.

Optionally, enter a description.

Select the location in which to save the cleanse asset.

Optionally, select a data quality dimension to represent the type of data quality issue that you want the asset to examine.

For more information about dimensions, see Cleanse assets and dimensions.

Save the cleanse asset.

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.

Optionally, add a tag to the cleanse asset. You can search for assets with a common tag on the Explore page.

Select 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.

Optionally, 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.

Add a step to each cleanse instance in the asset.

Select one of the following step types:

Convert Case

Remove Values

Remove Spaces

Replace Values

Configure the properties on the step to create an operation that the mapping can apply to the data.

Optionally, add one or more additional steps to each instance.

Configure the properties on each step that you add.

Optionally, configure a merge operation for two or more input fields. For information about configuring the fields to merge, see Merging records.

Save the asset.

After you configure the cleanse asset, test the asset with sample data.