I've a SQL Server data base that uses money data type, when I configure a tMSSql_Output the schema came with "MONEY" in the DB Type but when I link a tMap to this output the schema becames "Object", is I try to change tMap's schema to BigDecimal TOS says that schemas are different and give an error.
If I let it as Object (tMap) and execute the job I get this error: Data truncation - Line: 0
Is money data type supported? Is there any configuration that I could do to solve this?
Hello,
Thank you Shong. It help me.
But i like to understand why each talend component has its schema ? and how can i assure that all my schema are synchronized ?
Thank you !!