I had also faced the same issue recently. As I'm working with PostgreSQL database while inserting the data from Excel (.xlsx) file.
The PostgreSQL does not support zero in characters or 0x00 (unlike Oracle). You have to replace such chars with space or anything else.
In order to do so, you have to implement an expression in tMap to handle such situations.
Use below expression:
row1.your_column_name.replace("\\x00", " ")
For reference, follow below link:
This work for me. Give it a try.
How can we handle the same issue in Talend data Mapper.
I used below function while loading the data into PostgreSQL database.
i've uploaded the regex and replace string.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema