What is the use of Datacleanse transformation?
I want to know the use of datacleanse transformation?
In Diyotta we have implemented one transformation for dump users (mainly who are all don’t know how to apply functions) named as Datacleanse
When we drag Datacleanse transformation into canvas and click on select button then show preceding transformation attributes, after adding attributes automatically open Data Cleanse options popup.
-
- We don’t have option to add attributes, we can only select attributes from preceding transformation
-
- We have to select attributes for which we need to apply functions, and it has to open list of functions window by click on Data Cleanse option there we can see list of functions
-
- We can also apply multiple functions to an attribute
-
- It shouldn’t allows, when we apply functions to a wrong data type attributes and applied for valid data type attributes if those are present in the selected list (Ex: If we want to apply TRIM() function for attributes, one is having integer and another one have varchar so TRIM() will apply for only varchar type attributes)
-
- By using datacleanse transformation template we can apply and replace the existing function by select check box Replace existing functions