Class LookupTransformation<TInput, TSource>.PartialDbCacheSettings

Defines properties to configure a partial cache in a Lookup.

Inheritance
object
LookupTransformation<TInput, TSource>.PartialDbCacheSettings
Inherited Members
Namespace: ETLBox.DataFlow.LookupTransformation`2
Assembly: ETLBox.dll
Syntax
    public class LookupTransformation<TInput, TSource>.PartialDbCacheSettings

Properties

ClearCache

Default is true. The lookup cache is cleared after every batch of incoming data.

Declaration
    public bool ClearCache { get; set; }
Property Value
TypeDescription
bool

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
TypeDescription
int

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
TypeDescription
Func<TInput[], string>

SqlParameter

List of query parameters that are used to replace values in LoadCacheSql For every parameter provided, your sql statement should contain a placeholder. E.g.: 'SELECT col1 FROM table WHERE col2 > @parameter1'

Declaration
    public Func<TInput[], QueryParameter[]> SqlParameter { get; set; }
Property Value
TypeDescription
Func<TInput[], QueryParameter[]>