topic Re: merge statement in Talend in Talend Studio

merge statement in Talend

Anonymous — Mon, 09 Nov 2015 22:39:47 GMT

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,

Re: merge statement in Talend

Anonymous — Tue, 10 Nov 2015 07:36:46 GMT

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

Re: merge statement in Talend

Anonymous — Tue, 10 Nov 2015 14:38:48 GMT

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!