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
What is domain in terms of informatica?
without table how to come first record only in oracle?
Differences between version 7.x and 8.x.
Explain the difference between mapping parameter and mapping variable?
waht type of interface is used for testing the data in informatica
What is rank index in rank transformation?
What are the informatica performance improvement tips
Enlist few areas or real-time situations where informatica is required.
What is persistent lookup cache?
Scheduling properties,whats the default (sequential)
Describe the impact of several join conditions and join order in a joiner transformation?
What is a sequence generator transformation?
Explain the different dimensions.
What is mapplet in informatica?
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?