What are the differences between Connected and Unconnected lookup? - ETL

What are the differences between Connected and Unconnected lookup?



Connected Lookup:

- participates in mapping

- Returns multiple values

- Can be connected to another transformations and returns a value

Unconnected Lookup:

- It is used when lookup function is used instead of an expression transformation while mapping, where lookup does not available in the main flow

- Returns only one output port

- It cannot be connected to another transformation

- Unconnected Lookups are reusable.
Post your comment