Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between a connected look up and
unconnected look up?
- 6 Answers
- 25761 Views
- I also Faced
- E-Mail Answers
Answer Posted / suresh
1.conneted T/r takes multiple inputs and gives multiple
outputs
where as unconnected t/r takes multiple inputs but gives
single output
2. in connected lookup input, output, lookup ports are
available
where as in unconnected look up having input,output,lookup
as well as return port
3. connected t/r used dynamic and static cache
where as unconnected t/r uses only dynamic cache
| Is This Answer Correct ? | 19 Yes | 13 No |
Post New Answer View All Answers
What are the different components of powercenter?
What are the modules in Power Center
Name the different lookup cache(s)?
server hot-ws270 is connect to Repository B. What does it mean?
What is the need of an ETL tool?
What are the issues you have faced in your project? How did you overcome those issues?
Explain target update override in informatica
What is a pre-defined event and user-defined event?
What are mapplets? How is it different from a Reusable Transformation?
What are data-driven sessions?
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.
What is a grid in Informatica?
Where are the source flat files kept before running the session?
Write the unconnected lookup syntax and how to return more than one column.
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
