Data Populating as Null While Having Data in Source

[Anonymous]

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

[Anonymous]

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

Regards
Shong

[anselmopeixoto]

Hi @vishuoo1

It could be a type conversion issue.

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

[Anonymous]

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 🙂