⟩ Tell me can we override a native sql query within Informatica? Where do we do it? How do we do it?
Yes,we can override a native sql query in source qualifier and lookup transformation.
In lookup transformation we can find "Sql override" in lookup properties.by using this option we can do this.