RE: What is the use of Datacleanse transformation?

I want to know the use of datacleanse transformation?

Karthik78 Beginner Asked on May 18, 2020 in Diyotta Studio.
Add Comment
1 Answers

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.

RE: What is the use of Datacleanse transformation?

    • 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 

 

RE: What is the use of Datacleanse transformation?

    • We can also apply multiple functions to an attribute

 

RE: What is the use of Datacleanse transformation?

    • 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)

 

RE: What is the use of Datacleanse transformation?

    • By using datacleanse transformation template we can apply and replace the existing function by select check box Replace existing functions

 

RE: What is the use of Datacleanse transformation?

 

RE: What is the use of Datacleanse transformation?

  •  

 

Expert Answered on June 8, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.