What are the Differences between connected and unconnected
lookup?

Answer Posted / varma koilada

Connected lookup participates in the mapping ( dataflow )
just like any other transformation. Unconnected lookup is
used when a lookup function is used instead in an expression
transformation in the mapping in which case the lookup does
not appear in the main flow ( dataflow ) of the mapping.
Connected lookup can return more than one value ( output
port ) whereas Unconnected gives only one output port.
Unconnected lookups are reusable.

Is This Answer Correct ?    9 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If informatica has its scheduler why using third party scheduler?

759


How union transformation is used?

579


How to update a particular record in target with out running whole workflow?

1147


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

589


Different qualification between a related rotate toward the sky and isolates look upward?

543






What is the way to execute pl/sql script using informatica mapping?

950


What is a difference between complete, stop and abort?

630


Explain what is informatica metadata and where is it stored?

599


How can you validate all mappings in the repository simultaneously?

745


What is target load order?

794


Difference between Target-based loading and constraint-based loading?

544


r u done any partitions in ur project?

1389


What are active transformations.

1177


What is informatica etl tool?

541


can we override a native sql query within informatica? How do we do it?

634