Quick Tipp: What exactly is the match model in tMap?

When you do a join in tMap, you can define a Match Model.

It has different options:

Have you wondered what they mean?

Here is a short, but complete explanation for each of them:

Option “Unique Match”:

• works with inner join & left outer join
• default selection
• only last match passed on to output = other matches will be ignored

Option “First Match”:

• works with inner join & left outer join
• implies multiple matches expected in lookup
• only first match passed on to output = other matches will be ignored

Option “All Matches”:

• works with inner join & left outer join
• implies multiple matches expected in lookup
• all matches passed on to output = no matches ignored

Option “All Rows”:

• does not work with explicits join (inner join & left outer join)
• creates a cross join between main input and lookup(s)

See tMap Match Model in Action

Please refer to this video for an example.

Learn More: Complete Talend Course

If want to do more things like this and integrate your data esaily with Talend Open Studio, go to my Udemy Course.

This is a comprehensive training for using Talend to build data integration jobs, not only for Data Warehouses.

Read More

Thank you for your attention and see you soon!

Read similar articles here.