I have a talend job which reads from a .csv file and writes to a greenplum table using the "dynamic column" feature of Talend Enterprise Edition. Its a simple one to one mapping job.
The table structure is already defined and a few numeric/date fields are present.
Problem is dynamic data type is reading all fields as string and job is erroring out saying Column is of type numeric but expression is of string.
Can anyone help me in modifying the settings for dynamic datatype to detect numeric and date fields automatically.
Thanks for your reply.
The reason why we chose Dynamic datatype was because we do not know the column names and their datatypes. The same job has to run for multiple files.
Can you give me an example of how to convert in tmap? I have only one column of datatype Dynamic.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
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