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.
I didn't find the right solution from the Internet.
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.