Connected lookup is a mapping technique that returns several values. It can also be linked to another transformation and returns a value. When the lookup is not available in the main flow, an unconnected lookup is used, and it returns only one output. It cannot also be linked to another transformation, but it is reusable.