lookup sql override can be used in
What is SQL override and lookup override
Overriding the Lookup Query
Lookup Override SQL in Informatica
The lookup SQL override is similar to entering a custom query in a Source Qualifier transformation.
#informatica