It depends on the scenario u r using, if u want to lookup multiple times for the same condition in one mapping it is better to use unconnected lookup and in the situation like when u want multiple return values then u can only use connected lookup. In connected lookup, we can use  both static and dynamic cache but in case of unconnected lookup, we can use only static cache. 
from
vinod