Unanswered posts

  • Index
  •  » Talend Open Studio for Data Integration » Installation
  •  » In msql 2 tables have foreign key relationship how to validate

#1 2012-05-28 06:52:43

indira
Member
Registered: 2012-05-09
Posts: 125

In msql 2 tables have foreign key relationship how to validate

Hi,


In msql  2 tables have foreign key  relationship how to validate this condition for relate to psql

Offline

#2 2012-05-28 06:56:33

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: In msql 2 tables have foreign key relationship how to validate

Hi

You can use tMap to validate them.

Regards,
Pedro


Only Paranoid Survive.

Offline

#3 2012-05-28 09:39:51

indira
Member
Registered: 2012-05-09
Posts: 125

Re: In msql 2 tables have foreign key relationship how to validate

Hi,

How to tmap to validate plz give examples
I sent mail about this issue

Last edited by indira (2012-05-28 09:40:15)

Offline

#4 2012-05-28 12:54:09

indira
Member
Registered: 2012-05-09
Posts: 125

Re: In msql 2 tables have foreign key relationship how to validate

Hi,

I want to compare 2 columns,  with in the same database and two different tables how to validate this condition for relate to psql

Offline

#5 2012-05-28 12:59:02

janhess
Member
Company: Newcastle University
Registered: 2009-05-19
Posts: 1123

Re: In msql 2 tables have foreign key relationship how to validate

Do an inner join and you can have the output report on rejects.

Offline

#6 2012-05-28 13:52:31

indira
Member
Registered: 2012-05-09
Posts: 125

Re: In msql 2 tables have foreign key relationship how to validate

Hi Janhess,

I want compare 2 columns  based on a one condition

Offline

#7 2012-05-28 14:07:46

janhess
Member
Company: Newcastle University
Registered: 2009-05-19
Posts: 1123

Re: In msql 2 tables have foreign key relationship how to validate

look at the component documentation for tMap and tMysqlInput

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Installation
  •  » In msql 2 tables have foreign key relationship how to validate

Board footer

Powered by FluxBB