Which one is better performance wise connected/un-connected
lkp?why?
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
What are the types of lookup transformation?
State the differences between sql override and lookup override?
What are the different lookup cache(s)?
What is powercenter on grid?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Describe data concatenation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is a pre-defined event and user-defined event?
what are 3 tech challenges/ common issues you face?
Can we create a Integration service without a Repository service and vice versa?
What is the difference between STOP and ABORT options in Workflow Monitor?
What is a repository? And how to add it in an informatica client?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Where can we find the throughput option in informatica?
Explain the different dimensions.