Dynamically set schemas for JDBCinput and output

[Anonymous]

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?

[fdenis]

you can use dynamic type.

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

regards,

[Anonymous]

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?

[Anonymous]

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