Key value in tmap

Anonymous — Sat, 16 Nov 2024 08:04:04 GMT

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 Id	Class	Student Name			Student Id	Student Name	Class Id OID		Id	Class Id	Class Name
1	1	ABC			1	ABC	4		4	1	Grade 1
2	1	XYZ	TMAP Student Id & Class id oid is unique in Table B	2	XYZ	4		5	2	Grade 2
3	1	HJK	3	MNP	5		6	3	Grade 3
3	2	MNP					7	4	Grade 4
2	2	MLP	we want to insert the remaining student values from Table A		8	5	Grade 5

					3	HJK	4
					2	MLP	5

Thanks,

P.Nehru.

Re: Key value in tmap

Anonymous — Thu, 28 Jun 2018 09:18:32 GMT

Hello,

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

Best regards

Sabrina

topic Re: Key value in tmap in Talend Studio

Key value in tmap

Re: Key value in tmap