Designing a Job to implement the scenario
In order to implement this scenario, let's break down the Job into four steps:
-
Creation of the Job, configuration of the input file parameters, and reading of the input file,
-
Mapping of data and transformations,
-
Definition of the reference file parameters, relevant mapping using the tMap component, and selection of inner join mode,
-
Redirection of the output into a MySQL table.