merge statement in Talend

[Anonymous]

Hi,

I need to apply the below merge statement using any of the Talend components.

Any one please suggest me?


merge into mdmgeo.t_zip_code zc
using (select a.zip_cde,
              a.zip_cde_x_crdnt,
              a.zip_cde_y_crdnt
         from mdmgeo.t_zip_code a,
              mdmstggeo.t_ssi_rcd_2_main b
        where current_date between a.zip_cde_strt_dte and a.zip_cde_end_dte
          and a.zip_cde = b.zip_cde                   

          and (a.zip_cde_x_crdnt != b.picad_north_nbr
           or  a.zip_cde_y_crdnt != b.picad_west_nbr)) us on (zc.zip_cde = us.zip_cde) when matched then update
         set zip_cde_x_crdnt = us.zip_cde_x_crdnt,zip_cde_y_crdnt = us.zip_cde_y_crdnt

Thanks,

[Anonymous]

Hi,
where do you input source come from? Have you checked component tMap to see if it is what you are looking for?

Best regards
Sabrina

[Anonymous]

My input is oracle tables and no I haven't checked tmap component.
Can we implement merge statement as below in the tmap or in any other component.


merge into mdmgeo.t_zip_code zc
using (select a.zip_cde,
              a.zip_cde_x_crdnt,
              a.zip_cde_y_crdnt
         from mdmgeo.t_zip_code a,
              mdmstggeo.t_ssi_rcd_2_main b
        where current_date between a.zip_cde_strt_dte and a.zip_cde_end_dte
          and a.zip_cde = b.zip_cde                   
          and (a.zip_cde_x_crdnt != b.picad_north_nbr
           or  a.zip_cde_y_crdnt != b.picad_west_nbr)) us on (zc.zip_cde = us.zip_cde) when matched then update
         set zip_cde_x_crdnt = us.zip_cde_x_crdnt,zip_cde_y_crdnt = us.zip_cde_y_crdnt


Thanks!