Interested to Buy Any Domain ? << Click Here >> for more details...
Which one is better performance wise connected/un-connected
lkp?why?
- 2 Answers
- 14157 Views
- HCL, TCS, I also Faced
- E-Mail Answers
Answer Posted / rayudu
Connected lookup is used to lookup on each and every row
bjut unconnected lookup is used to lookup only when the
condition is true i,e unconnetcec is used only for selectetd
rows so obviously unconnected is faster .
Regards,
rayudu.
| Is This Answer Correct ? | 18 Yes | 3 No |
Post New Answer View All Answers
Explain sessions. Explain how batches are used to combine executions?
Can u generate reports in Informatica?
list out all the transformations which use cache?
What is difference between a gateway node and worker node?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are the limitations of joiner transformation?
What is the use of target designer?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Explain the shared cache and re-cache?
What is a connected transformation?
Implementation methodology
what is diff b/t sorter t/r and agg have the option sorter property...
what is informatica metadata?
tell me 5 session failure in real time how can you solve that in your project?
What is a node in Informatica?
