Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
I am trying to load table from mysql to redshift using dynamic schema. but Im getting the below error
"Error converting data, invalid type for parameter:3"
can someone what should i do to resolve this.
job design:
tmysqlinput with dynamic schema-->tmap-->tredshiftoutput with dynamic schema(settings create table and insert)
but how to generate "create statement" dynamically using this sys tables....should we have to write a java code or is there a straight forward way to do this in Talend using some components?
I wanted to do this for all tables before loading data in single job....using tablelist i can get the tables and then i can get the sys columns...but wht would be the next step to generate create statment using this?
please suggest!