Answer Detail: RE: Unconnected Lookup

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Print |

Question: Unconnected Lookup

Answer: In which situation do we use unconnected lookup?

June 06, 2009 02:34:11	#3
pooja.verma	Member Since: June 2009 Total Comments: 2
RE: Unconnected Lookup
Unconnected lookup should be used when we need to call same lookup multiple times in one mapping. For example, in a parent child relationship you need to pass mutiple child id's to get respective parent id's. One can argue that this can be achieved by creating resusable lookup as well. Thats true, but reusable components are created when the need is across mappings and not one mapping. Also, if we use connected lookup multiple times in a mapping, by default the cache would be persistent.