Using a context variable to select a repository schema

[Anonymous]

I have a job that iterates through multiple flat files and loads them into database tables. info about the load is derived from the file names.  I lookup the file properties from a config table in the database that tells me the row separator, delimiter, and name of the repository schema.  Is there any way to insert the schema name or otherwise manipulate the __SCHEMA__ variable since I seem to be unable to insert the context variable in that box?

[Anonymous]

Hi,

    I don't think you will be able to dynamic change the schema value. If you are trying to create an ingestion framework, Dynamic schema will help you in this regard. Please refer below blogs to get more idea in this area.

https://www.talend.com/blog/2019/10/31/magically-shuffle-columns-talend-dynamic-schema/

https://www.talend.com/blog/2019/11/11/migrate-data-between-databases-one-job-using-dynamic-schema/

Please note that Dynamic schema is available only in enterprise version of Talend.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved