Key value in tmap

Five Stars

Key value in tmap

Hi All,

 

We need to fetch the data from Mysql table A and update/insert into Mysql table B, Please find the sample data below and suggest how to handle the Mysql tmap (I mean in B table Student id & class_id_oid combination is unique, so how we can maintain the key value in both source and destination table of tmap).

 

Mysql Table A   Mysql Table B  Mysql Table C 
        foreign key    
Student IdClassStudent Name  Student IdStudent NameClass Id OID IdClass IdClass Name
11ABC  1ABC4 41Grade 1
21XYZ

TMAP

Student Id & Class id oid is unique in Table B

2XYZ4 52Grade 2
31HJK3MNP5 63Grade 3
32MNP    74Grade 4
22MLPwe want to insert the remaining student values from Table A 85Grade 5
            
     3HJK4    
     2MLP5    

 

 

Thanks,

P.Nehru.

Moderator

Re: Key value in tmap

Hello,

Did you want to insert column "Class" into your table B? What does your expected result look like?

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.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads