What is one disadvantage of using an unconnected (sometimes called function mode) Lookup transformation? (1) If there is no match in the Lookup condition, the Informatica server returns a transformation error(2) A reusable unconnected Lookup can not have more than one instance in a mapping(3) An unconnected Lookup transformation does not support user-defined default values(4) An unconnected Lookup transformation does not support a static lookup cache

  • Interview Candidate
  • 4
  • 9875

Showing Answers 1 - 4 of 4 Answers

shahab

  • Oct 29th, 2007
 

Unconnected lookup does not support User defined values and it also does not  support Dymamic Cache.

prashant.baranwal

  • Sep 19th, 2010
 

What is one disadvantage of using an unconnected (sometimes called function mode) Lookup transformation?

(1) If there is no match in the Lookup condition, the Informatica server returns a transformation error
Ans: It is true for both connected and unconnected lookup

(2) A reusable unconnected Lookup can not have more than one instance in a mapping
Ans: But it cannot be a disavantage for unconnected lookup as it can be called anywhere in the mapping. It is an extra advantage indeed.

(3) An unconnected Lookup transformation does not support user-defined default values
Ans: For unconnected lookup, in case when it doesn't find a match it can only return NULL. While a connected lookup can be configured to return a user defined value. So, here it is a disadvantage with unconnected lookup.

(4) An unconnected Lookup transformation does not support a static lookup cache
Ans: It is false. Both lookups support static cache.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions