What is diff between connected and unconnected lookup?
Answer Posted / ramesh
the main difference between connected and unconnected is
connected:
recieves data from source table in a pipeline.
it returns multiple columns
it supports user defined default values
unconnected:
recieves data from result of the lookup expresion on other transformation
it returns one column
it doesnt supports use defined default values
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a shortcut and copy in Informatica and how two are different with each other?
How do you update the records with or without using update strategy?
Explain the types of lookup transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
What are the informatica performance improvement tips
How to load the data from a flat file into the target where the source flat file name changes daily?
Which transformation should we use to normalise the COBOL and relational sources?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is informatica worklet?
Describe the impact of several join conditions and join order in a joiner transformation?
can u any challenge your project?
What is primary and backup node?
server hot-ws270 is connect to Repository B. What does it mean?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
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 ?