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 65

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

—

Submitted by: paddy

sq is a connected transform. cant do it.

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

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

0 1

Overall Rating: -1

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

1 0

Overall Rating: +1

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

0 1

Overall Rating: -1

Go To Top

User Name		Remember Me?
Password

Question Bank