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

Interview Candidate
Sep 13th, 2005
3
4139

First
Prev
Next
Last

Showing Answers 1 - 3 of 3 Answers

sivaram.jogi
Profile Answers by sivaram.jogi

Nov 3rd, 2005

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

paddy

Dec 6th, 2005

sq is a connected transform. cant do it.

anjanroy
Profile Answers by anjanroy

Apr 14th, 2006

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.