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
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Reusable transformation and shortcut differences
Explain sessions and how many types of sessions are there?
Is stop and abort are same in informatica?
Explain the types of lookup transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How many number of sessions can one group in batches?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
what is unit testing?tell me proceedure
How to create or import flat file definition in to the warehouse designer?
Is it possible to use a client with different version than that of its Informatica server?
What is substr in informatica?
How do you load unique records into one target table and duplicate records into a different target table?
Implementation methodology