Tuesday, March 19, 2013
When we go for unconnected lookup transformation? and why?
1. When we want to get single return value also we can call this anywhere in the mapping.
2. In addition to this it gives you the flexibility to run lookup for selected source rows which u don’t find in connected lookup.
3. When number of records are less go for unconnected lookup, which improve the performance.