Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between a connected look up and
unconnected look up?
- 6 Answers
- 25751 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasuna
1) A connected Lookup transformation receives input values
directly from another transformation in the pipeline.
An unconnected Lookup transformation receives input values
from the result of a :LKP expression in another
transformation. You can call the Lookup transformation more
than once in a mapping.
2)IN connected The Integration Service passes return values
from the query to the next transformation.
In Unconnected The Integration Service returns one value
into the return port of the Lookup transformation.
3)Connected uses Dynamic or Static Cache,whereas
Unconnected use a static cache
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
In how many ways we can create ports?
Does an informatica transformation support only aggregate expressions?
how to load dimension table and fact table. plz tell me the steps.
where to store informatica rejected data? How to extract the informatica rejected data?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Write the unconnected lookup syntax and how to return more than one column.
State the differences between sql override and lookup override?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How do you set a varible in incremental aggregation
What is main use of mapplet?
Why do we need informatica?
without table how to come first record only in oracle?
What are the different types of olap? Give an example?
What are the tasks that source qualifier perform?
What is data movement mode in Informatica and difference between them?
