|
Answer» Lookup TRANSFORMATIONS can both be used in connected and unconnected modes. Following is a comparison of the connected and unconnected lookup transformations: | Connected Lookup | Unconnected Lookup |
|---|
| Data is directly received as input values from the transformation and also contributes to the data flow. | It does not directly take the values; it only receives them from the RESULT or function of the LKP expression. | | For synchronization, it is connected to the database. | No synchronization technique is in place. | | Expressions and other transformations can't be done with it. | Though unconnected lookup does not take input directly from other transformations, it is still USEFUL in any transformation. | | This method cannot be CALLED more than once in a mapping. | This method can be called multiple times in a mapping. | | User-defined DEFAULT values are supported. | User-defined default values are not supported. | | It supports both dynamic and static cache. | It supports only static cache. | | More than one column value can be returned, i.e., output port. | Only one column value can be returned. |
|
