Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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://community.talend.com/t5/Data-Quality-Preparation-and/Data-Quality-Profiling-among-several-ta...
Logistics Solution Example

Thanks!

Labels (2)
1 Reply
msjian
Employee
Employee

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