Data Quality Profiling among several tables

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.
Moderator

Re: Data Quality Profiling among several tables

Hi,
Could you please elaborate your case with an example with input and expected output values?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Re: Data Quality Profiling among several tables

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?

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Introduction to Talend Open Studio for Data Quality

Find out about Talend Open Studio for Data Quality

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read