I have an oracle table which have two columns of date format. When i pull the data from Db to Excel those are shown as -1. The code is working fine in my local DB, but when i deploy it in Unix machine im facing this issue. Can you anyone help me with this
Did you deploy your Job on Talend Runtime to retrieve data from your database? Are you referring to this related scenario:TalendHelpCenter: Scenario: Deploying your Job on Talend Runtime to retrieve data from a MySQL datab...?
In advanced settings of tfileoutputexcel component, have you tried to set the "Encoding" as UTF-8 to see if it works?
What's the locale encoding of your unix server?
If the project starts with the -Dfile.encoding=UTF-8 set, try to change the locale encoding to UTF-8.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how and why companies are moving to the Cloud
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.