Unique Match | First Match | All match |
In this mode, only the first occurrence of a matching record in the output table is considered. | This mode is similar to the Unique Match module,as it also selects the first occurrence of a matching record. | In the All Match mode, all matching records from the input table are considered. |
It ensures that each record from the input table is matched with a unique record in the output table. | However, unlike Unique Match, it allows multiple records from the input table to match with the same record in the output table. | It enables multiple matches for a record in the output table, allowing all matching records from the input to be associated with it. |
If multiple records in the inp.ut table match the same record in the output table, only the first match is retained | In this mode, all the matching records from the input table are included in the output, but only the first occurrence is marked as a match. | This mode can result in a one-to-many relationship between input and output records, where one output record may have multiple corresponding input records. |
Unique match option gives the last matching record in the lookup table. | First match option gives the first matching record in the lookup table. | All match option gives all matching record in the lookup table. |
The Blog focuses on all Related interview questions required at Scenario level with Solution description.
types of match modules in tmap
Subscribe to:
Posts (Atom)