Saturday, November 17, 2007

Unconnected Lookup transformation

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

Choose Answer

(A)
If there is no match in the Lookup condition, the Informatica server returns a transformation error.
(B)
A reusable unconnected Lookup can not have more than one instance in a mapping.
(C)
An unconnected Lookup transformation does not support user-defined default values.
(D)
An unconnected Lookup transformation does not support a static lookup cache.

4 comments:

said...

(C)

Arun Kumar said...

Thank you for the valuable information of Lookup transformation. You will get more information regarding the API and programming stuffs for Lookup transformation for SSIS in the below link.
http://www.sqllion.com/2009/05/programming-lookup-transformation/

abeer pareek said...

C

nj said...

C