null
US
Entrar
Registre-se gratuitamente
Registre-se
Detectamos que o JavaScript não está habilitado no teu navegador. Habilite o Javascript para o funcionamento correto do nosso site. Por favor, leia os
Termos e Condições
para mais informações.
Próximo
Copiar e Editar
Você deve estar logado para concluir esta ação!
Inscreva-se gratuitamente
343953
Lookup query
Descrição
1 INFA (Lookup Transformation) Mapa Mental sobre Lookup query, criado por dbrown em 09-11-2013.
Sem etiquetas
infa
lookup transformation
infa
lookup transformation
1
Mapa Mental por
dbrown
, atualizado more than 1 year ago
Mais
Menos
Criado por
dbrown
quase 11 anos atrás
33
0
0
Resumo de Recurso
Lookup query
Default query
SELECT
All lookup ports
Can generate sql
Don't change ports/columns
ORDER BY
orders the columns by the same order they appear in the lookup
IS generates the order by
you can't see this when you generate sql in sql override
Overriding
ORDER BY clause with fewer colums
Increase performance
suppress ORDERBY with comment notation
cannot override or suppress when using pushdown optimization
-- at the end
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
reswords.txt
can put reserved words in
put in installation dir
IS will look at this file and put quotes in query
Can use parameters and variables
in the query
as a query
IS expands variables at run time
/ slash char in column name
IS converts to _ underscore
1 generate default query
2 replace _ underscore with / slash
3 enclose in double quotes
add a WHERE clause
limit rows
DYNAMIC cache - use a filter before with same condition
uncached
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
do not change
to reference input ports in the WHERE clause, configure parameter binding
SELECT EMPLOYEE.NAME as NAME, max(EMPLOYEE.ID) as ID from EMPLOYEE WHERE EMPLOYEE.NAME=?NAME1?
You cannot use subqueries in the SQL override for uncached lookups. Lookup
Filtering source rows
lookup source filter
caching enabled
pushdown optimization
creates a voew
properties tab
do not include WHERE
Enclose parms & vars in string identifies
Quer criar seus próprios
Mapas Mentais
gratuitos
com a GoConqr?
Saiba mais
.
Semelhante
Lookup trans
dbrown
Properties of Lookup
dbrown
Lookup condition
dbrown
Lookup Ports
dbrown
Returning multiple rows
dbrown
Lookup Cache
dbrown
Database Deadlock Resilience
dbrown
Transformation Functions
dbrown
Lookup Ports - created from Mind Map
dbrown
Lookup condition - created from Mind Map
dbrown
Lookup Cache - created from Mind Map
dbrown
Explore a Biblioteca