Data Cleanse Transformation Tutorial in Astera Centerprise
In this video, we’ll show you how you can clean, refine, and standardize your source data using the Data Cleanse Transformation object found under the Transformations section of the dataflow toolbox. This object allows you to remove unnecessary data, remove nulls, perform find and replace functions, specify the case of data, and apply expressions on the data fields of the source data.
Our objective in this tutorial:
Using the Data Cleanse Transformation in Astera Centerprise.
Replace null numeric fields with zeros.
Perform Normal Find and Replace function.
Apply Title case to the source data.
Apply a regular expression function on all data fields in the source data.