Implementing 'Rank' function in DS Server jobs

[yaminids]

Friends,

My new assignment requires me to extract data from 3 different tables present in 3 different schemas, in the source, to one staging table in the destination db.

In other terms, the requirement is to select the data based on the VENDOR column (VENDOR=1)

Check if the first table (in 1st schema) has VENDOR=1 then select data from table 1, if not check if second table (in 2nd schema) has VENDOR=1 then select data from table 2 and so on

I could do this using 'Rank' function if all the 3 tables are in one schema but since they are in different schemas complicates the matters

Is there a way to implement 'Rank' function in Server jobs using 'Link collector'

ODBC-1 ======>
ODBC-2 ======>Link Collector====>ODBC
ODBC-3 ======>

Thanks
Yamini

[ray.wurlod]

No.

You will need to attempt all the lookup and go with the first non-null result.

This is not a RANK function.