# Creating the Jobs

Before creating, configuring, and executing the Jobs in this example, make sure:

* Each of the input files comes with a header row that contains the names of the columns in the file.
* The MySQL tables have the columns whose names are identical to those of the corresponding source files.
* The source files are available in your file system.

## Creating the parent Job

### Procedure

1. Create a standard Job and name it LoadDynamicSchemaParent.
2. Place the following components onto the design workspace, and label them according to their roles in the Job.
   | Component | Label |
   | --- | --- |
   | tFileList | File\_list |
   | tIterateToFlow | File\_name\_flow |
   | tMap | File\_table\_lookup |
   | tFixedFlowInput | Mappings |
   | tJavaRow | Set\_context\_variables |
   | tRunJob | Call\_child |
3. Connect the components:
   1. tFileList to tIterateToFlow using a Row > Iterate connection
   2. tIterateToFlow to tMap using a Row > Main connection
   3. tFixedFlowInput to tMap using a Row > Main connection, as a lookup connection
   4. tMap to tJavaRow using a Row > Main connection (named out in this example)
   5. tJavaRow to tRunJob using a Row > Main connection

   ![Screenshot of the Job in the Designer.](https://help.qlik.com/talend/en-US/data-integration-job-examples/Resources/images/dynamicschema_jobexample_parentjob.png)

## Creating the child Job

### Procedure

1. Create a standard Job and name it LoadDynamicSchemaChild.
2. Place the following components onto the design workspace, and label them according to their roles in the Job.
   | Component | Label |
   | --- | --- |
   | tFileInputDelimited | Input\_file |
   | tDBOutput | Write\_to\_DB |
3. In the Basic settings view of the tDBOutput component, select MySQL from the Database list and click Apply.
4. Connect the tFileInputDelimited component to the tDBOutput component using a Row > Main connection.

   ![Screenshot of the Job in the Designer.](https://help.qlik.com/talend/en-US/data-integration-job-examples/Resources/images/dynamicschema_jobexample_childjob.png)