Database Reference
In-Depth Information
Property
Description
Sorted input
Check this option if you are passing sorted data to the Lookup transformation. Passing the sorted data enhances performance.
Lookup source
is static
This indicates that the lookup source is not changing while processing the data.
Pre-build look-
up cache
This indicates whether Integration Service builds the cache before the data enters the Lookup transformation. The default is
Auto
.
Subsection
precision
This property indicates the subsection precision you wish to set for the date/time data.
We have now seen all the details of Lookup transformations.
