Interested to Buy Any Domain ? << Click Here >> for more details...
Which one is better performance wise connected/un-connected
lkp?why?
- 2 Answers
- 13954 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
How do you promote a non-reusable transformation to reusable transformation?
How can we delete duplicate rows from flat files?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
list out all the transformations which use cache?
What is substr in informatica?
how to load rows into fact table in data warehouse
What is the different lookup cache(s)?
How to load data in informatica ?
What are the tasks that source qualifier perform?
Explain the scenario which compels informatica server to reject files?
In warehouses how many schemas are there?
What is an aggregator transformation?
What is source qualifier transformation in informatica?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
