Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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-ta...
Logistics Solution Example
Thanks!
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