topic Data Quality Profiling among several tables in Data Quality

Data Quality Profiling among several tables

Anonymous — Sat, 16 Nov 2024 09:58:39 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.

Re: Data Quality Profiling among several tables

Anonymous — Thu, 23 Mar 2017 07:29:02 GMT

Hi,
Could you please elaborate your case with an example with input and expected output values?
Best regards
Sabrina

Re: Data Quality Profiling among several tables

Anonymous — Thu, 23 Mar 2017 07:44:12 GMT

Lets say,
I have three tables.
1.Individual(Attributes: Pkey,First_Name,Last_Name)
2.IndEmail (Attributes: Ind_Key(PK-FK relationship with Individual ),Email,First_Name,Last_Name)
3. IndPhone (Attributes: Ind_Key (PK-FK relationship with Individual ),Phone_Number)

[color=#1f497d][font=Calibri, sans-serif] I have to join these three tables and check the health of the data for Pkey,First_Name,Last_Name,Phone_Number,Email.[/font][/color]
How to achieve this?

Re: Data Quality Profiling among several tables

msjian — Wed, 08 Jan 2020 09:11:57 GMT

you can create Redundancy Analysis to check

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

Regards
Jian
----------------------------------------------------------
Talend | Data Quality