null
US
Sign In
Sign Up for Free
Sign Up
We have detected that Javascript is not enabled in your browser. The dynamic nature of our site means that Javascript must be enabled to function properly. Please read our
terms and conditions
for more information.
Next up
Copy and Edit
You need to log in to complete this action!
Register for Free
346185
Lookup condition
Description
1 INFA (Lookup Transformation) Mind Map on Lookup condition, created by dbrown on 10/11/2013.
No tags specified
infa
lookup transformation
infa
lookup transformation
1
Mind Map by
dbrown
, updated more than 1 year ago
More
Less
Created by
dbrown
almost 11 years ago
44
0
0
Resource summary
Lookup condition
like a WHERE clause
Data types must match
must have
multiple conditions
evaluates as AND
Optimize order
1- equal =
2<,>,<=,>=
3 (not) !=
matches NULL values
dynamic cache
can only use = (equal)
Handling Multiple Matches
Use first or last value
lookup cache order
use any
create index on keys
return ALL rows
active
cant switch
return an error
static or no cache
marks the row
shows in session log
increases error count
dynamic
fails the session
Show full summary
Hide full summary
Want to create your own
Mind Maps
for
free
with GoConqr?
Learn more
.
Similar
Lookup trans
dbrown
Properties of Lookup
dbrown
Lookup query
dbrown
Lookup Ports
dbrown
Returning multiple rows
dbrown
Lookup Cache
dbrown
Database Deadlock Resilience
dbrown
Lookup query - created from Mind Map_1
dbrown
Transformation Functions
dbrown
Lookup Ports - created from Mind Map
dbrown
Lookup Cache - created from Mind Map
dbrown
Browse Library