ETL - where do we use connected and un connected lookups

GeekInterview.com > Interview Questions > Data Warehousing > ETL

Go To First | Previous Question | Next Question

ETL | Question 36 of 65

where do we use connected and un connected lookups

Total Answers and Comments: 4

Last Update: November 06, 2006 Asked by: ravi

Sponsored Links

Best Rated Answer

—

Submitted by: venkata veluguri

We can use more than one return port using Un-connected Lookup (Lookup override).

As per my knowledger Un-connected Lookup is useful when we need to call the same lookup multiple times in the mapping.

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

June 13, 2006 04:47:30

Srinivas Kuncham

RE: where do we use connected and un connected lookups...

If return port only one then we can go for unconnected. More than one return port is not possible with Unconnected. If more than one return port then go for Connected.

Is this answer useful? Yes | No

August 02, 2006 08:13:15

Satyaranjan Puthal

RE: where do we use connected and un connected lookups...

Exactly You are fully correct

Is this answer useful? Yes | No

October 15, 2006 11:21:53

venkata veluguri

RE: where do we use connected and un connected lookups...

We can use more than one return port using Un-connected Lookup (Lookup override).

As per my knowledger Un-connected Lookup is useful when we need to call the same lookup multiple times in the mapping.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

November 06, 2006 03:39:07

PFD333

RE: where do we use connected and un connected lookups...

Unconected lookups are used in cases where it is not necessary for all the rows to pass through it i.e. for each i/p row query need not be done.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank