Today I'm going to demonstrate the sample results produced by Talend Data Quality (DQ) Tool. This gives us an idea how is DQ useful for you data migration projects.
To save our time I added many screen-shots of resultant analysis, you will find more functional ideas of Talend DQ.
Overview:
Talend Data Quality is a data profiler tool that can help us to know our data more deeply. It supports database, csv, excel (file based) and MDM data connections for profiling and cleansing.Simple Use Case:
Let say you have an excel file and you have to do a data migration task with that file. One way to start the task is open that file and check row by row the data of that file, select column and apply filters to check the redundant data, that is very time consuming work.
Another way to do that, use Talend Data Quality tool and do the same task in some clicks with many other useful details.
In short DQ can do the following tasks:-
By using this Talend Data Quality we can get following details of our data:-
(a) Catalog Analysis shows total number of rows, columns, indexes, view, keys and table listing with rows, keys and index.
(b) Table Analysis show various table data details.
Column Analysis:
Database Compare:
