# Using Dynamic Schema to load data dynamically to database tables

This example describes how to leverage the Dynamic Schema feature to load data dynamically.

Information noteWarning: This documentation is relevant only if you are using a subscription-based Talend Studio.

The content of the following three flat files will be loaded to MySQL database tables named customer, employee and delivery respectively:

* customer\_detaials.csv:
  ```
  first_name;last_name;order_date
  Reita;Leto;2012-05-15
  Larae;Gudroe;2011-08-07
  Clay;Hoa;2014-04-16
  Irma;Wolfgramm;2012-09-10
  Sylvia;Cousey;2013-02-25
  ```
* employee\_details.csv:
  ```
  id;name;gender;email;department;order_date
  1;Sage;Male;sage_wieser@cox.net;R&D;2012-05-15
  2;Kris;Female;kris@gmail.com;Test;2011-08-07
  3;Abel;Male;amaclead@gmail.com;HR;2014-04-16
  4;Mattie;Female;mattie@aol.com;Test;2012-09-10
  5;Bernardo;Female;bfigeroa@aol.com;Marketing;2013-02-25
  ```
* delivery\_details.csv:
  ```
  Name;Datetime
  Reita;2012-02-11 15:30:32
  Larae;2015-08-28 09:30:32
  ```

The example involves two Jobs one calling the other: the parent Job maps the file names to table names in the database, and the child Job reads data from the files and writes the data to the corresponding database tables.

### In this section

* [Prerequisites to this Job example](https://help.qlik.com/talend/en-US/data-integration-job-examples/7.3/prerequisites-to-this-job-example)
* [Creating the parent Job](https://help.qlik.com/talend/en-US/data-integration-job-examples/7.3/creating-parent-job)
* [Creating the child Job](https://help.qlik.com/talend/en-US/data-integration-job-examples/7.3/creating-child-job)
* [Configuring the parent Job](https://help.qlik.com/talend/en-US/data-integration-job-examples/7.3/configuring-parent-job)
* [Configuring the child Job](https://help.qlik.com/talend/en-US/data-integration-job-examples/7.3/configuring-child-job)
* [Executing the parent Job and check the data loading result](https://help.qlik.com/talend/en-US/data-integration-job-examples/7.3/executing-parent-job-and-check-data-loading-result)