http://powerblog.mauricets.nl/2011/02/union-in-lookup-sql-override/
Informatica Powercenter : UNION in Lookup SQL Override