In lookup which one is better one connected and unconnected lookup?performance wise i am asking?if i am using five connected lookup in mapping that time what happens?
RE: In lookup which one is better one connected and un...
Yes Exactly Depends.
Definitely unconnected is better performance wise.
But its not wise to use 5 unconnected lookups. In this case better to use one connected with the required 5 ports as output port. If u need only one or two output port, you can use unconected for better performance.
RE: In lookup which one is better one connected and un...
how can u say that unconnected is better performance then connected lookup.
in connected lookup we are going to use only lookup table in unconnected we are going to add an expersion with lookup table then the performance in unconnected lookup is decreased due to another transformation than connected lookup
RE: In lookup which one is better one connected and un...
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
RE: In lookup which one is better one connected and un...
it depends on the requirement. If you want to retrieve more than one port values then use connected(dynamic/static cache). If you want to retrieve one port value then use unconnected(static cache).
RE: In lookup which one is better one connected and un...
Unconnected lookup can also be used to return multiple values through one port. Override the lookup query to concatenate all the return columns from the lookup table and parse the value in the expression where lookup is being called.
RE: In lookup which one is better one connected and un...
Unconnected Lookup is always better..It takes less time as compared to that of Connected Lookup.Because Unconnected Transformation is Isolated within the mapping,we can call this lookup with the help of a Expression transformation.Where as connectedloopup is connected in a single pipeline from source to target.
RE: In lookup which one is better one connected and un...
Unconnected is better by performance wise, bcoz unconnected look up does not invove in the mapping, we are calling from another transformation, so it mimimizes the lookup cache value In connected, it is connected to the tranformations, so it keeps values in lookup cache.
