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 let me know how to make encryption and decryption with example?
Define joiner transformation?
What are connected or unconnected transformations?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is the way to execute pl/sql script using informatica mapping?
How many ways a relational source definition can be updated and what are they?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are the limitations of joiner transformation?
explain one complex mapping with logic? sales project?
Differentiate between a repository server and a powerhouse?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Define Pmrep command?