Lookup Transformation Properties – Informatica

  • Updated
  • Posted in Programming
  • 4 mins read


Lookup Property Lookup Type Description Lookup SQL Override Relational Override the default sql question generated by the lookup transformation. Use this selection when lookup cache is enabled. Lookup Table Name Pipeline
Relational You can select a supply, goal or supply qualifier because the lookup desk title. This is the lookup supply which might be used to question or cache the info.

If you could have override the sql question, then you may ignore this selection

Lookup Source Filter Relational You can filter trying up within the cache primarily based on the worth of information within the lookup ports. Works solely when lookup cache is enabled. Lookup Caching Enabled Flat File
Pipeline
Relational When lookup cache is enabled, the mixing service queries the lookup supply as soon as and caches all the knowledge. Caching the lookup supply improves the efficiency. If the caching is disabled, the mixing service queries the lookup supply for every row.

The integration service at all times caches the flat file and pipeline lookups

Lookup Policy on Multiple Match Flat File
Pipeline
Relational Which row to return when the lookup transformation finds a number of rows that match the lookup situation.
Report Error: Reports error and doesn’t return a row.
Use Last Value: Returns the final row that matches the lookup situation.
Use All Values: Returns all matched rows.
Use Any Value: Returns the primary worth that matches the lookup situation. Lookup Condition Flat File
Pipeline
Relational You can outline the lookup situation within the situation tab. The lookup situation is displayed right here. Connection Information Relational specifies the database that incorporates the lookup desk. Source Type Flat File
Pipeline
Relational Indicates the lookup supply kind: flat file or relational desk or supply qualifier. Tracing Level Flat File
Pipeline
Relational Set quantity of element to be included within the lookup Lookup Cache Directory Name Flat File
Pipeline
Relational Specifies the listing used to construct the lookup cache recordsdata Lookup Cache Persistent Flat File
Pipeline
Relational Use when the lookup supply knowledge doesn’t change in any respect. Examples: zipcodes, nations, states and so forth.

The lookup caches the info as soon as and it makes use of the cache even in a number of session runs.

Lookup Data Cache Size Lookup Index Cache Size Flat File
Pipeline
Relational Cache sizes of the lookup knowledge and lookup index Dynamic Lookup Cache Flat File
Pipeline
Relational Indicates to make use of a dynamic lookup cache. Inserts or updates rows within the lookup cache because it passes rows to the goal desk. Output Old Value On Update Flat File
Pipeline
Relational Use with dynamic caching enabled. When you allow this property, the Integration Service outputs previous values out of the lookup/output ports. When the Integration Service updates a row within the cache, it outputs the worth that existed within the lookup cache earlier than it up to date the row primarily based on the enter knowledge. When the Integration Service inserts a row within the cache, it outputs null values. Update Dynamic Cache Condition Flat File
Pipeline
Relational An expression that signifies whether or not to replace dynamic cache. Create an expression utilizing lookup ports or enter ports. The expression can comprise enter values or values within the lookup cache. The Integration Service updates the cache when the situation is true and the info exists within the cache. Use with dynamic caching enabled. Default is true. Cache File Name Prefix Flat File
Pipeline
Relational Use with persistent lookup cache. Specifies the file title prefix to make use of with persistent lookup cache recordsdata. Recache From Lookup Source Flat File
Pipeline
Relational The integration service rebuilds the lookup cache. Insert Else Update Flat File
Pipeline
Relational Use with dynamic caching enabled. Applies to rows getting into the Lookup transformation with the row kind of insert. Update Else Insert Flat File
Pipeline
Relational Use with dynamic caching enabled. Applies to rows getting into the Lookup transformation with the row kind of replace. Datetime Format Flat File Specify the date format for the date fields within the file. Thousand Separator Flat File specify the thousand separator for the port. Decimal Separator Flat File Specify the Decimal Separator for the port. Case-Sensitive String Comparison Flat File The Integration Service makes use of case delicate string comparisons when performing lookups on string columns. Null Ordering Flat File
Pipeline Specifies the way to kind null knowledge. Sorted Input Flat File
Pipeline Indicates whether or not the lookup supply knowledge is in sorted order or not. Lookup Source is Static Flat File
Pipeline
Relational The lookup supply doesn’t change in a session. Pre-build Lookup Cache Flat File
Pipeline
Relational Allows the Integration Service to construct the lookup cache earlier than the Lookup transformation receives the info. The Integration Service can construct a number of lookup cache recordsdata on the similar time to enhance efficiency. Subsecond Precision Relational Specifies the subsecond precision for datetime ports.

Leave a Reply