ETLBox
Title here
Summary here
LookupTransformation<TInput, TSource>.PartialDbCacheSettings
Class LookupTransformation<TInput, TSource>.PartialDbCacheSettings
Defines properties to configure a partial cache in a Lookup.
Inherited Members
Namespace: ETLBox.DataFlow.LookupTransformation`2
Assembly: ETLBox.dll
Syntax
public class LookupTransformation<TInput, TSource>.PartialDbCacheSettingsProperties
EvictionPolicy
The eviction policy used for the partial cache. By default, the cache is fully refreshed for every batch.
Declaration
public CacheEvictionPolicy EvictionPolicy { get; set; }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
public int LoadBatchSize { get; set; }Property Value
| Type | Description |
|---|---|
| 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
| 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
public int MaxCacheSize { get; set; }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
public Func<TInput[], QueryParameter[]> SqlParameterSelector { get; set; }Property Value
| Type | Description |
|---|---|
| Func<TInput[], QueryParameter[]> |