Class LookupTransformation<TInput, TSource>.PartialDbCacheSettings

Defines properties to configure a partial cache in a Lookup.

Inheritance

object

LookupTransformation<TInput, TSource>.PartialDbCacheSettings

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: ETLBox.DataFlow.LookupTransformation`2

Assembly: ETLBox.dll

Syntax

{{< /rawhtml >}} ```C# public class LookupTransformation.PartialDbCacheSettings ``` {{< rawhtml >}}

Properties

EvictionPolicy

The eviction policy used for the partial cache. By default, the cache is fully refreshed for every batch.

Declaration

{{< /rawhtml >}} ```C# public CacheEvictionPolicy EvictionPolicy { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
CacheEvictionPolicy

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

{{< /rawhtml >}} ```C# public int LoadBatchSize { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
int

LoadCacheSql

A custom sql to load data from the lookup source based on the input batch.

Declaration

{{< /rawhtml >}} ```C# public Func LoadCacheSql { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
Func<TInput[], string>

MaxCacheSize

Defines the max amount of rows stored in the partial cache if the eviction policy is set to a different value than FullRefresh.

Declaration

{{< /rawhtml >}} ```C# public int MaxCacheSize { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
int

SqlParameterSelector

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

{{< /rawhtml >}} ```C# public Func SqlParameterSelector { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
Func<TInput[], QueryParameter[]>