Data Quality Profiling among several tables

Anonymous — Tue, 12 Jun 2018 15:56:04 GMT

Hi,

I am using Talend Open Studio DQ 6.3 in order to do profiling for the tables who is interconnected by PK-FK relationship.
I have almost 25 tables which are interconnected through PF-FK relationship.
I need to do the profiling to check whether all the PK-FK relationship is in place correctly and data quality for the corresponding columns is in right shape.
I request you to guide me how to do this sort of profiling.

Please help.

I didn't find the right solution from the Internet.

References:-
https://community.talend.com/t5/Data-Quality-Preparation-and/Data-Quality-Profiling-among-several-tables/td-p/187350
Logistics Solution Example

Thanks!

Re: Data Quality Profiling among several tables

msjian — Wed, 15 Aug 2018 08:45:35 GMT

hi
i think you can use

Redundancy Analysis -> Column Content Comparison(old version name)
Cross Table Analysis -> Redundancy Analysis(7.1.1 renamed)
This analysis compares the data of two sets of columns. You can use this analysis to verify foreign key/primary key relationships or to compare the content of two tables.

Thanks
Jian

topic Data Quality Profiling among several tables in Data Quality

Data Quality Profiling among several tables

Re: Data Quality Profiling among several tables