When is connect and unconnected looks–ups used?

In the event that arrival port just one, at that point we can go for detached. More than one return port is preposterous with Unconnected. In the event that more than one return port, at that point, go you should use Connected Looks – ups.

On the off chance that you require dynamic reserve that is where your information will change progressively, at that point you can go for associated query. On the off chance that your information is static where your information won't change when the session loads you can go for Unconnected Look – ups.