ISSUE WHILE UPDATING USING FULL OUTER JOIN

Anonymous — Sat, 12 Dec 2015 11:50:50 GMT

hi,
i have to create output table('patient_full_info') from multiple input tables('patient','doctor') irrespective of matching columns in input tables.
Sample Input tables:
patient(patientid(PK),patientname,gender,bloodgroup,phone,adharid)-MYSQL
doctor(doctorid(PK),doctorname,doc_phone,doc_gender,pat_adharid)-Postgres database

Sample output table:
patient_full_info(patientid,patientname,adharid(PK),doctorname)-MYSQL

So, i am using FULL OUTER JOIN and created a job.Till now works fine.All data from source tables copied to destination table('patient_full_info')

IMPLEMENTATION OF FULL JOIN:
i made 'patient' as main table and 'doctor' as lookup table and used 'LEFT OUTER JOIN' between them and linked to 'tMap1'.Secondly, i made 'doctor' as main table and 'patient' as lookup table and used 'LEFT OUTER JOIN' between them and linked to 'tMap2'.And merged two tMap's using tUnite_1 and then given output data to 'tMysqlOutput'

Is this the correct way of implementing FULL OUTER JOIN ??

Then i created one CDC JOB to capture any updates in source tables('patient','doctor') and to update those changes in output table('patient_full_info') using 'FULL OUTER JOIN'.

When i update a column from any of input tables(eg:changed column 'patientname' in 'patient' table.Updated name is not reflecting in output table),my job is failling to update values in output table('patient_full_info').

Please look into screen shots for your reference.
Help me to solve this issue.

Re: ISSUE WHILE UPDATING USING FULL OUTER JOIN

Anonymous — Mon, 14 Dec 2015 11:14:39 GMT

Any update please ??

topic Re: ISSUE WHILE UPDATING USING FULL OUTER JOIN in Talend Studio

ISSUE WHILE UPDATING USING FULL OUTER JOIN

Re: ISSUE WHILE UPDATING USING FULL OUTER JOIN