Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

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

April 26, 2017called disadvantage function lookup mode Transformation unconnected

0

Posted

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

1 Answer

0

Posted

(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