What are the Differences between connected and unconnected
lookup?

Answer Posted / mayur

Connected Lookup
- In mapping flow (Pipeline)
- One or more output (Multiple return port)
- Can Assigned Default Value
- Have to create new if more than one table to lookup in the same mapping
Unconnected Lookup
- Not in mapping flow
- Only one output (Single return port)
- Can’t assign default value
- Can use multiple time

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is domain in terms of informatica?

552


without table how to come first record only in oracle?

1837


Differences between version 7.x and 8.x.

1401


Explain the difference between mapping parameter and mapping variable?

592


waht type of interface is used for testing the data in informatica

1823






What is rank index in rank transformation?

595


What are the informatica performance improvement tips

599


Enlist few areas or real-time situations where informatica is required.

578


What is persistent lookup cache?

591


Scheduling properties,whats the default (sequential)

1448


Describe the impact of several join conditions and join order in a joiner transformation?

630


What is a sequence generator transformation?

563


Explain the different dimensions.

540


What is mapplet in informatica?

582


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

761