Can we lookup a table from a source qualifer transformation-unconnected lookup

No. we can't do.
I will explain you why.
1) Unless you assign the output of the source qualifier to another transformation or to target
no way it will include the feild in the query.
2) source qualifier don't have any variables feilds to utalize as expression.