| By using Lookup Override, you can avoid scanning the whole table by limiting the number of lookup rows, thus saving time and cache. |
By using SQL Override, you can limit how many rows come into the mapping pipeline. |
| By default, it applies the "Order By" clause. |
When we need it, we need to manually add it to the query. |
| It only supports one kind of join i.e., non-Equi join. |
By writing the query, it can perform any kind of 'join'. |
| Despite finding multiple records for a single condition, it only provides one. |
This is not possible with SQL Override. |
