Unconnected Look Up Transformation: Unconnected lookup is generally used when the result of a query is a single column. More importantly, if it returns values like that indicate Does the record exist, whats the value of this column and so. It can return only one input , but it is reusable and can save you a lot of effort in some cases where its applicable.