Can Anyone suggest best Tools for Data Validation in CloverETl.
Like for SSIS Packages we use SSIS Tester and Querysurge for other ETL .
Hi jaipal,
I would highly recommend the following validation tools we offer.
Data Reader policy—All our data readers work with selectable data policy which affects how errors in the input data are treated. Different policies allow different reactions to data errors from strict reject over to controlled logging or completely lenient behavior.
Validator—Validator allows you to specify a set of rules using a powerful drag&drop visual designer and check the validity of incoming data based on these rules. Validation rules can check various criteria like date format, numeric value, interval match, phone number validity and format, etc.
Data Profiler—Let’s you discover potential issues in your data. Calculates statistics such as ranges, averages or histograms for data profiling overview. Also offers trend analysis for TDQM setups.
Address Validation & Cleansing—Using Address Doctor to provide parsing of address details, verification and enrichment including geo coding.
Email Address Validation—Reads from input and parses e-mail addresses from specified fields.
You can also check out more information on how each one of these tools work in our documentation.