Skip to main content Skip to complementary content

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.

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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here