Using Dynamic Schema to load data dynamically to database tables

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.