Interested to Buy Any Domain ? << Click Here >> for more details...
What is diff between connected and unconnected lookup?
- 5 Answers
- 9004 Views
- BirlaSoft, Blue Star Infotech, I also Faced
- E-Mail Answers
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 are the basic requirements to join two sources in a source qualifier transformation using default join?
What is meant by LDAP users?
What is the benefit of session partitioning?
How we can create indexes after completing the loan process?
What is workflow? What are the components of the workflow manager?
Differentiate between a repository server and a powerhouse?
What are the modules in Power Center
How to convert multiple rows to single row (multiple columns) in informatica
What is an aggregator transformation?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is a grid in Informatica?
State the limitations where we cannot use joiner in the mapping pipeline?
What is Session and Batches?
Differentiate between a database and data warehouse?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
