What is difference between a connected look up and
unconnected look up?
- 6 Answers
- 23681 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
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Explain the shared cache and re-cache?
How many ways are there to create ports?
What are the new features of informatica 9.x in developer level?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is option by which we can run all the sessions in a batch simultaneously?
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.
Design a mapping to load the cumulative sum of salaries of employees into target table?
How can we delete duplicate rows from flat files?
Can we create multiple integration service on single repository?
Explain why we use partitioning the session in informatica?
While migrating the data from one environment to another environment how would you manage the connections?
What is a standalone command task?
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
