Designing a Job to implement the scenario
The scenario comprises the following 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.