Data Cleansing
CloverETL is a versatile tool which can be also used for data cleansing. Its specialized transformation language allows implementing even very complex validation rules.
Clover offers several transformation components which can be used for building data cleansing transformations:
- ApproximativeJoin - joining data based on similarity, not only exact match
- Approximative Lookup - looking up values based on similarity of reference and lookup key
- E-Mail Checker - validating e-mail adresses (both in active and passive mode)
Clover Transformation Language (CTL) further broadens the pallette of data cleansing focused functionality by offering edit distance, soundex, metaphone, NYSIIS and other functions.
The standard set of data cleansing and validating components and functions is furher extended by specialized address validation and cleansing add-ons, which implement interfaces to following systems:
Data Cleansing solution using CloverETL
Read Data Cleansing Case Study
which shows benefits of a usage of ClovetETL for data validation and data cleansing.