What are the differences between Connected and Unconnected lookup? - ETL
ETL (extract, transform, and load) Testing Interview Questions
(Continued from previous question...)
12. What are the differences between Connected and Unconnected lookup? - ETL
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.
(Continued on next question...)
Other Interview Questions
|