I developed a job in talend which loads data into specific tables from excel and excel has some % values in it.But while loading the data into it DB, if data has special characters (%,- )in some field like Amount , the actual amount is converting to zero.Could you please help how to solve this?
Can you confirm the excel-sheet and DB table data type for these amount and actual amount fields?
In general if you have string data type for excel and in DB you are using nvarchar, it will not show any zero amount or blank value.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.