topic Re: Issue while fetching the record based on column after talend DB Load in Talend Studio

Issue while fetching the record based on column after talend DB Load

Anonymous — Thu, 07 Nov 2019 02:46:07 GMT

Hi Team,

We are facing very weird issue while data is loaded from source (Postgres DB) to target (Postgres DB).

Data is loaded successfully in DB but when we refer the country column in one of our query to fetch the data in SQL editor then it's doesn't return any record and soon when we use trim in same column then it works.

select accnt_cntry_cd from vmrctta1.vmrraccnt_mc_extrt_stg
where trim(accnt_cntry_cd)='513';

However, we have applied trim in all our source but still we have this trim issue. Can someone please suggest what will be issue as we need value in country column without Whitespace.

Note: Source country column datatype is Varchar(5) where as target table same column is bpchar(5).

But I believe that will not be issue as other table with same setup is working fine.

We are using TOS.

Re: Issue while fetching the record based on column after talend DB Load

manodwhb — Thu, 07 Nov 2019 05:28:28 GMT

@rohitatcs , this is issue with of datatypes between source and target.

Re: Issue while fetching the record based on column after talend DB Load

Anonymous — Thu, 07 Nov 2019 05:48:18 GMT

@manodwhbIf that is the case, we have other tables with same scenario which is working perfectly fine.

Re: Issue while fetching the record based on column after talend DB Load

manodwhb — Thu, 07 Nov 2019 05:50:36 GMT

@rohitatcs ,can you check the filed length and data type in each and every component and DB side also.

Re: Issue while fetching the record based on column after talend DB Load

Anonymous — Thu, 07 Nov 2019 11:21:18 GMT

Data type changes doesn't help.

Can you please suggest the approach to handle this.