Thanks for all the good feedback on my last blog on tLogCatcher. This blog will cover how Talend tMap component performs multiple joins and filtering functions.
We will use the above (Figure 1) data set as an example. There are 3 separate CSV files that store Student, Subject and Enrolment information.
In Figure 2, you can see from the process that the Enrolment data is the main data while the Student and Subject data will be used as the lookup data.
Inner Join Example
If we use Inner Join as the Join Model for the Subject and Student data, the Enrolment records that do not have relationship with Subject and Student table will be filtered. You can see the result in Figure 4.