ETL - What are the different Lookup methods used in Informatica?

GeekInterview.com > Interview Questions > Data Warehousing > ETL

Go To First | Previous Question | Next Question

ETL | Question 10 of 65

What are the different Lookup methods used in Informatica?

Total Answers and Comments: 8

Last Update: August 03, 2007

Sponsored Links

Best Rated Answer

—

Submitted by: Gowtham

Connected transformation is connected to other transformations or directly to target table in the mapping. An unconnected transformation is not connected to other transformations in the mapping. It is called within another transformation, and returns a value to that transformation. Connected lookup receives input values directly from mapping pipeline whereas UnConnected lookup receives values from: LKP expression from another transformation. Connected lookup returns multiple columns from the same row whereas UnConnected lookup has one return port and returns one column from each row. Connected lookup supports user-defined default values whereas UnConnected lookup does not support user defined values.

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

May 20, 2005 15:36:58

suman

RE: What are the different Lookup methods used in Informatica?

connected lookup transformation and un connected look up transformation

Is this answer useful? Yes | No

July 07, 2005 19:07:30

srilu

RE: What are the different Lookup methods used in Informatica?

connected lookup will receive input from the pipeline and sends output to the pipeline and can return any number of values

Unconnected lookup can return only one column

Is this answer useful? Yes | No

September 09, 2005 06:06:24

karthik

RE: What are the different Lookup methods used in Informatica?

connected lookup will receive input from the pipeline and sends output to the pipeline and can return any number of values.it does not contain retun port .
Unconnected lookup can return only one column. it containn return port.

Is this answer useful? Yes | No

December 13, 2005 06:00:55

Sithu

RE: What are the different Lookup methods used in Info...

Connected / unconnected lookup Transformations are used in Informatica

Sithu

Is this answer useful? Yes | No

January 05, 2006 06:22:10

Gowtham

RE: What are the different Lookup methods used in Info...

Connected transformation is connected to other transformations or directly to target table in the mapping. An unconnected transformation is not connected to other transformations in the mapping. It is called within another transformation and returns a value to that transformation. Connected lookup receives input values directly from mapping pipeline whereas UnConnected lookup receives values from: LKP expression from another transformation. Connected lookup returns multiple columns from the same row whereas UnConnected lookup has one return port and returns one column from each row. Connected lookup supports user-defined default values whereas UnConnected lookup does not support user defined values.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

March 14, 2006 06:31:00

ravi kumar guturi

RE: What are the different Lookup methods used in Info...

In the lookup transormation mainly 2 types

1)connected 2)unconnected lookup

Connected lookup: 1)It recive the value directly from pipeline

2)it iwill use both dynamic and static

3)it return multiple value

4)it support userdefined value

Unconnected lookup:it recives the value :lkp expression

2)it will be use only dynamic

3)it return only single value

4)it does not support user defined values

Is this answer useful? Yes | No

September 14, 2006 02:25:11

Anup Kumar

RE: What are the different Lookup methods used in Info...

My dear ravi

unconnected Lookup never use Dynamic cache it use only Static cache. and one thing more may be it happend by mistake but u should know that if u r giving answer it will read by many people who can be freshers and he has not much knowledge regarding cache. so it will give wrong effect to them.

Is this answer useful? Yes | No

August 03, 2007 07:38:28

rudra

RE: What are the different Lookup methods used in Info...

Hi!Lookups are two types: 1) Connected 2) Unconnected

Connected is further two types 1) Static 2) Dynamic connected lookup is used while returning single or multiple returning values but unconnected can return only single return value. static and dynamic are the caches that can be configured during the session. in dynamic inserts and updates occurs in cache during the session while in static there will be no such process. remember whenever you use dynamic lookup you have to place an update strategy transformation before the target table.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank