Looking for some urgent help here with below issue.
In the Input file I have data like below for the field acct_ID.
The input file of .csv type and in talend work flow there is no formatting as such for this field.
But when this data loads into mySQl database it is replacing the last digit as zero and not the correct number.
What could be the issue and the fix for this?
Output: (wrong o/p)
If no transformation on Talend side, maybe a before insert trigger on MySQL side.
Even if I output this to simple csv from talend it is doing the same.
Any modification to input field I need to do to avoid the replacement of exact value to zero.
It sounds so strange, double check your job.
If already done, triple check it.
Can you also share your job design and maybe settings for principal components.
I am using Encoding as UTF-8,
no dynamic setting as such for input file and output file.
I have attached the design and metadata. Could you please check it.
But when I open with notepad++ the output field shows me correct format but not as normal csv it shows me wrong output replacing the last digit to zero.
And in MySQL also wrong output replacing the last digit as zero.
I will try a trigger now before insert.
DELIMITER // CREATE TRIGGER contacts_before_insert BEFORE INSERT ON contacts FOR EACH ROW BEGIN END; // DELIMITER ;