A Cleanse transformation works in a similar way to a Mapplet transformation. You connect the transformation inputs and outputs to other objects in the mapping in the same manner as a mapplet connects to other mapping objects. When you run the mapping, the Cleanse transformation applies the cleanse asset logic to the input fields and generates an output field that you can connect to a downstream transformation.
After the mapping runs, you can evaluate the data output to determine if the data meets the standardization objectives.
Rules and guidelines for cleanse assets and mappings
Consider the following rules and guidelines when you work with mappings and cleanse assets:
•A cleanse asset is a reusable object. You can add a cleanse asset to transformations in multiple mappings. A Cleanse transformation is a nonreusable object. You select a Cleanse transformation when you configure a mapping.
•To view the list of cleanse assets that you created, navigate to the Explore page.
•If you update a cleanse asset that you previously added to a transformation, you must synchronize the transformation with the cleanse asset.
To synchronize the transformation, open the transformation in the mapping and select the Cleanse properties. Data Integration displays a message that prompts you to synchronize the transformation with the cleanse asset.