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.
