Data Quality Profiling among several tables

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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?

[msjian]

Hi

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