Four Stars

Data Quality Profiling among several tables

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://www.talendforge.org/forum/viewtopic.php?id=56464
Logistics Solution Example

Thanks!

1 REPLY
Employee

Re: Data Quality Profiling among several tables

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