August 2017
Beginner to intermediate
426 pages
9h 36m
English
Let's discuss the properties of Lookup transformation:
|
Property |
Description |
|
Lookup SQL override |
This is similar to SQL override. When you override the default query generated by the Lookup transformation in order to extract the data from relational tables, it is referred to as Lookup SQL override. |
|
Lookup table name |
This is the name of the table on which you are looking up using Lookup transformation. |
|
Lookup source filter |
Integration service will extract only those records that satisfy the filter condition defined. |
|
Lookup cache enabled |
This property indicates whether Integration service caches data during processing. Enabling this property enhances the performance. |
|
Lookup policy ... |
Read now
Unlock full access