Dynamic schema script for loading data from file to Database table

[Anonymous]

Hi

I have a scenario where I need to dynamically load data from csv file into Database table. When ever new columns gets added in Flat file it should dynamically reads the data from the flat file and load into MySQL database table and also I need  script in tjavarow to run this scenario 

please help with some option.

Thanks!!

[Anonymous]

Hi Vidya,

      You will not be able to modify the schema structure of DB components (like MySQL) on the fly. But another approach is to store the metadata information separately and parse the data based on the metadata.

     Could you please refer below Talend blog for details?

https://www.talend.com/blog/2016/03/11/how-to-operationalize-meta-data-in-talend-with-dynamic-schema...

Warm Regards,

Nikhil Thampi

[Anonymous]

Hi Nikhilthampi,

Can you please elaborate me with some more example and components to be used for this dynamic schema??

[Anonymous]

Hi,

      Please refer the below blogs and community posts which is having details related to this topic.

https://community.talend.com/t5/Design-and-Development/tMap-with-Dynamic-schema/td-p/43409

https://community.talend.com/t5/Design-and-Development/resolved-I-want-to-create-a-generic-talend-jo...

http://edwardost.github.io/talend/di/2015/07/19/dynamic-mapping/

If the reply has helped to resolve your query, could you please mark the topic as closed? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi