Lookup properties can be configured depending upon the lookup source Relational or Flat file.
|
Property
|
Lookup Type
|
Description
|
|
SQL Override
|
Relational
|
Customize the default statement generated by
lookup.
|
|
Lookup Table Name
|
Relational
|
Specifies the name of the table from which
the transformation lookup and cache values.
|
|
Lookup Source filter
|
Relational
|
It works only when lookup cache enabled. We
can filter looking up in the cache based on the value of data in the lookup
port.
|
|
Lookup caching Enabled
|
Flat File,
Relational
|
Power center server wether caching the lookup
values during the session.
|
|
Lookup Policy on
Multiple Mtch
|
Flat file,
Relational
|
There are multiple records in lookup table
for given condition lookup will return the ouput by using this property.
|
|
Lookup Condition
|
Flat file,
Relational
|
We can setup the lookup condition, which displays
here.
|
|
Connection Information
|
Relational
|
Specifies the Database creting lookup table.
|
|
Source Type
|
Flat
file, Relational
|
Specifies the source type which is database
or flat file.
|
|
Lookup Cache directory name
|
Flat
file, Relational
|
Location which is used to create cache files.
|
|
Lookup cache persistent
|
Flat
file, Relational
|
Use persistent cache or not.
|
|
Lookup Data Cache Size
|
Flat
file, Relational
|
Cache sizes of the lookup data.
|
|
Lookup Index Cache Size
|
Flat
file, Relational
|
Cache sizes of the lookup index.
|
|
Dynamic Lookup Cache
|
Flat
file, Relational
|
Whether to use dynamic cache or not.
|
|
Output Old value on update
|
Flat
file, Relational
|
Use with dynamic caching enabled. When you
enable this property, the Integration Service outputs old values out of the
lookup/output ports.
|
|
Cache file name prefix
|
Flat
file, Relational
|
Use only with persistent lookup cache.
Specifies the file name prefix to use with persistent lookup cache files.
|
|
Re cache from lookup source
|
Flat
file, Relational
|
Integration service rebuilds the lookup
cache.
|
