Overriding

ORDER BY clause with fewer colums
If the table name or any column name in the lookup query contains a reserved word, you must ensure that all reserved words are enclosed in quotes
Can use parameters and variables
/ slash char in column name
add a WHERE clause
uncached
Increase performance
suppress ORDERBY with comment notation
cannot override or suppress when using pushdown optimization
-- at the end
reswords.txt
can put reserved words in
put in installation dir
IS will look at this file and put quotes in query
in the query
as a query
IS expands variables at run time
IS converts to _ underscore
1 generate default query
2 replace _ underscore with / slash
3 enclose in double quotes
limit rows
DYNAMIC cache - use a filter before with same condition
must use "Use Any Value Lookup Policy on Mulitple Match condition to override the lookup query
IS does NOT build
uses alias's for column names
to reference input ports in the WHERE clause, configure parameter binding
You cannot use subqueries in the SQL override for uncached lookups. Lookup
do not change
SELECT EMPLOYEE.NAME as NAME, max(EMPLOYEE.ID) as ID from EMPLOYEE WHERE EMPLOYEE.NAME=?NAME1?

	Created by dbrown over 10 years ago

	Copied to Note by dbrown over 10 years ago

1 INFA (Lookup Transformation) Note on Lookup query - created from Mind Map_1, created by dbrown on 11/10/2013.

Lookup query - created from Mind Map_1