You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2017-03-21 14:17:01

Shovan Mazumder
Member
2 posts

Shovan Mazumder said:

Data Quality Profiling among several tables

Tags: [development]

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.

Offline

#2 2017-03-23 08:29:02

xdshi
Talend Team


xdshi said:

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


What we can do is to make sure that Talend will be your best choice!

Offline

#3 2017-03-23 08:44:12

Shovan Mazumder
Member
2 posts

Shovan Mazumder said:

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)


I have to join these three tables and check the health of the data for Pkey,First_Name,Last_Name,Phone_Number,Email.
How to achieve this?

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy