Dynamically set schemas for JDBCinput and output

Four Stars

Dynamically set schemas for JDBCinput and output

Hello!

 

I am stuck...

 

Is there a way to set the schema of an input and output objects using csv mapping file or table or global variables?

 

Eleven Stars

Re: Dynamically set schemas for JDBCinput and output

you can use dynamic type.

https://help.talend.com/reader/XYG1yAFeBFz4I4dovmWbsQ/Sqn2UjC4NG9K7BRgJys7zg

regards,

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Four Stars

Re: Dynamically set schemas for JDBCinput and output

Thanks!

And what if I know what columns will be in the input component and to what do they correlate in the output component. Can I use xml or something to generate appropriate schemas and perhaps a map?
Moderator

Re: Dynamically set schemas for JDBCinput and output

Hello,

Please take a  look at tSetDynamicSchema component which sets a dynamic schema that can be reused by components in the subsequent subjob or subjobs to retrieve data from unknown columns.

Here is the related scenario:https://help.talend.com/reader/sKo4uqbrmujonWygOCuUuA/1NJaZNl5e3WPQd7I65gKOg

Let us know if it is what you are looking for.

Best regards

Sabrina

 
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.