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

[Anonymous]

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.

[manodwhb]

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

[Anonymous]

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

[manodwhb]

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

[Anonymous]

Data type changes doesn't help.

Can you please suggest the approach to handle this.