ETL - can we lookup a table from source qualifier transformation. ie. unconnected lookup

GeekInterview.com > Interview Questions > Data Warehousing > ETL

Go To First | Previous Question | Next Question

ETL | Question 28 of 64

can we lookup a table from source qualifier transformation. ie. unconnected lookup

Total Answers and Comments: 3

Last Update: April 14, 2006 Asked by: asha

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

November 03, 2005 00:31:02

sivaram.jogi

Member Since: November 2005 Contribution: 1

RE: can we lookup a table from source qualifier transf...

I think we cannot lookup through a source qualifier as we use the souce to look up the tables so it is not possible i think

Is this answer useful? Yes | No

December 06, 2005 11:24:56

paddy

RE: can we lookup a table from source qualifier transf...

sq is a connected transform. cant do it.

Is this answer useful? Yes | No

April 14, 2006 08:42:57

anjanroy

Member Since: September 2005 Contribution: 4

RE: can we lookup a table from source qualifier transf...

You cannot lookup from a source qualifier directly. However, you can override the SQL in the source qualifier to join with the lookup table to perform the lookup.

Is this answer useful? Yes | No

Go To Top