What is diff between connected and unconnected lookup?
Answer Posted / padmavathi
Connected Lookup:
Part of the mapping dataflow.
Returns multiple values by linking output ports to
another transformation
Executed for every record passing through the transformation
More Visible, shows where the lookup values are used.
Unconnected Lookup:
Seperate from the mapping dataflow.
Returns one value by checking the return port option for
the output that provides the return value
only executed when the lookup function is called
Less visible, as the look is called from an expression
within another transformation
Default values are ignored
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is meant by LDAP users?
What is the benefit of partitioning a session?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Make a note of the quantity vaults made in informatica?
How identifying bottlenecks in various components of informatica and resolving them?
How to open an older version of an object in the workspace?
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?
Explain the different kinds of facts.
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Explain the different dimensions.
Clarify the aggregator change?
How to update or delete the rows in a target, which do not have key fields?
How will the document be delivered to me?
How to load data in informatica ?
Write the prerequisite tasks to achieve the session partition?