topic Data Populating as Null While Having Data in Source in Talend Studio

Data Populating as Null While Having Data in Source

Anonymous — Tue, 26 Mar 2019 11:43:06 GMT

Hi All,

I have data in source table and it is having one to one mapping with Target table's columns. One column is populating as Null in target table (postgresql). Could anyone tell me what could be the issue. First time i am facing this issue.

Thanks in Advance

Regards,

Vishal Vats

9650236023

Re: Data Populating as Null While Having Data in Source

Anonymous — Mon, 08 Apr 2019 09:33:24 GMT

Use a tLogRow to print the value after you read them from the source to make sure the data is correctly read.

Regards
Shong

Re: Data Populating as Null While Having Data in Source

anselmopeixoto — Sat, 13 Apr 2019 16:08:04 GMT

Hi @vishuoo1

It could be a type conversion issue.

Try to filter the row which outputs null value and run as Traces Debug.

Re: Data Populating as Null While Having Data in Source

Anonymous — Thu, 18 Apr 2019 10:41:57 GMT

Hi Vishal,

The best to identify this issue is to activate the Die on error option in tDBOutput component.

The reason could be wrong data type, invalid values, length is not within permissible limits etc. Once you select this option, it will provide the right error message.

Also double check whether you have correctly mapped value to this column in previous components and you have not missed the data mapping to this column.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂