Executing the Job
Procedure
- Press Ctrl + S to save your Job.
- Press F6 to run the Job.
Results
The four output files are all created in the specified folder, containing information as defined. The output file No_Reseller_ID.csv contains the cars information related to reseller IDs 5 and 8, which are missing in the input file Resellers.csv.
For examples of how to use dynamic schemas with tMap, see:
As third advanced use scenario, based on the scenario 2, add a new Input table containing Insurance details for example.
Set up an Inner Join between two lookup input tables (Owners and Insurance) in the Mapper to create a cascade lookup and hence retrieve Insurance details via the Owners table data.