Informatica - What is one disadvantage of using an unconnected (sometimes called function mode) Lookup transformat

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 568 of 644

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

Total Answers and Comments: 3

Last Update: October 16, 2008 Asked by: Santosh Bharamshetty

Sponsored Links

Best Rated Answer

—

Submitted by: shahab

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

Above answer was rated as good by the following members:
ggazulas

September 24, 2007 13:04:25

vemurisasidhar

Member Since: August 2007 Contribution: 10

RE: What is one disadvantage of using an unconnected (...

i think the answer should be choice 1

Is this answer useful? Yes | No

0 1

Overall Rating: -1

October 29, 2007 03:36:34

shahab

RE: What is one disadvantage of using an unconnected (...

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

Is this answer useful? Yes | No

1 0

Overall Rating: +1

October 16, 2008 17:00:10

vivek.gce

Member Since: October 2008 Contribution: 1

RE: 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 ha

If there is no match in the Lookup condition the Informatica server returns a transformation error.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank