Difference between Connected and UnConnected Lookup Transformation:
Connected lookup receives input values directly from mapping pipeline
whereas UnConnected lookup receives values from: LKP expression from another transformation.
Connected lookup returns multiple columns from the same row
whereas UnConnected lookup has one return port and returns one column from each row.
Connected lookup supports user-defined default values
whereas UnConnected lookup does not support user defined values.
Subscribe to:
Post Comments (Atom)
2 comments:
What other transformations can be unconnected in Informatica?
www.themartianview.com
Most importantly , unconnected lookup transformation can be called multiple times within a mapping which is not possible in case of connected lookup transformation.
www.etl-techie.blogspot.com
Post a Comment