The Definitive Guide to Data Quality
- Is there a limit to the number of sources you can use in tMap?
- Can I explicitly set the join expression to perform complex joins?
Example: (Src1.FieldA=Src2.FieldA AND Src1.FieldB > Src2.FieldB AND Src1.FieldB < Src2.FieldC)
From what I can tell it appears that the tMap component does one large in-memory hash to join the data sets.