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
If informatica has its scheduler why using third party scheduler?
How union transformation is used?
How to update a particular record in target with out running whole workflow?
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?
Different qualification between a related rotate toward the sky and isolates look upward?
What is the way to execute pl/sql script using informatica mapping?
What is a difference between complete, stop and abort?
Explain what is informatica metadata and where is it stored?
How can you validate all mappings in the repository simultaneously?
What is target load order?
Difference between Target-based loading and constraint-based loading?
r u done any partitions in ur project?
What are active transformations.
What is informatica etl tool?
can we override a native sql query within informatica? How do we do it?