What is a default lookup query and in which circumstances you should override it?

Informatica Integration service runs a default SQL statement when the first row enters the lookup transformation in the pipeline. Default Lookup Query If there is no SQL override and no filter specified the integration service generates a default SQL to query the lookup. It contains following components:- SELECT:-┬áThe select statement includes all the lookup ports […]