What is the difference between Connected and UnConnected
Lookup Transformation.Give me one or two examples please?
Answer Posted / pradeep
1) The connected lookup t/r connected other transformations in the pipe line and it recives input data directly from pipe line.
where as unconnected lookpup t/r not connected other t/r in the pipe line and it recive input data from the result of :LKP Expression in an other t/r,that support expressions.
2)Connected lookup support user defined functions
Unconnectd doesn't support user defined functions.
3) It returns multiple output values to other t/r
Unconnected returns single output value to other t/r.
4)Connected lookup support static and dynamic cache
Unconnected supports only static cache.
5)Connected lookup cache includes output ports in the lookup condition
Where as in unconnected lookup cache include lookup ports of lookup condition.
6)Connected lookup gives multiple output ports to other t/r.
Unconnected lookup gives single output port to other t/r.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is song in infrmatica...?
design of staging area?
How to open an older version of an object in the workspace?
What is the way to execute pl/sql script using informatica mapping?
can you please explain me pre session and post session options?
What is the difference between stop and abort in informatica
what is informatica metadata?
what is degenerated dimension?
What is mapping debugger?
What is expression transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is repository manager?
difference between informatica 8.1.1 and 8.6
What is a pre-defined event and user-defined event?