Class LookupTransformation<TInput, TSource>.PartialDbCacheSettings
Defines properties to configure a partial cache in a Lookup.
Inheritance
System.Object
LookupTransformation<TInput, TSource>.PartialDbCacheSettings
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: ETLBox.DataFlow.Transformations
Assembly: ETLBox.dll
Syntax
public class PartialDbCacheSettingsProperties
ClearCache
Default is true. The lookup cache is cleared after every batch of incoming data.
Declaration
public bool ClearCache { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
LoadBatchSize
The cache is filled not for every row, but for a batch of rows to improve throughput. Define here the number of rows for every batch.
Declaration
public int LoadBatchSize { get; set; }Property Value
| Type | Description |
|---|---|
| System.Int32 |
LoadCacheSql
A custom sql to load data from the lookup source based on the input batch.
Declaration
public Func<TInput[], string> LoadCacheSql { get; set; }Property Value
| Type | Description |
|---|---|
| System.Func<TInput[], System.String> |