What are the Differences between connected and unconnected
lookup?
- 6 Answers
- 19455 Views
- TCS, I also Faced
- E-Mail Answers
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
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is native users?
How do we call shell scripts from informatica?
How to create the source and target database connections in server manager?
How to extract sap data using informatica? What is abap? What are idocs?
What is Index Caches size?
How many ways a relational source definition can be updated and what are they?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
scenario where i can use only concurrent execution of workflow.
What is union transformation in informatica?
Tell me about MD5 functions in informatica
What is a repository? And how to add it in an informatica client?
How can one identify whether mapping is correct or not without connecting session?
what are the Methods For Creating Reusable Transformations?
Explain what are the different types of transformation available in informatica.
