IEtlTask.PartialFetch

Fore Syntax

PartialFetch: Boolean;

Fore.NET Syntax

PartialFetch: boolean;

Description

The PartialFetch property determines whether ETL task uses partial data sampling.

Comments

Available values:

True. The task uses partial data sampling.
False. The task does not use partial data sampling.

By default, data from sources is calculated in the whole that requires much memory and is often not allowed. To speed up data read process, use this property. To set the number of processed records, use IEtlTask.DefaultBlockSize or IEtlPlainDataProvider.FetchBlockSize.

Fore Example

Executing the example requires that the repository contains an ETL task with the T_ETL identifier.

Add links to the Etl, Metabase system assemblies.

Sub UserProc;
Var
    MB: IMetabase;
    MObj: IMetabaseObject;
    EtlTask: IEtlTask;
Begin
    MB := MetabaseClass.Active;
    MObj := MB.ItemById("T_ETL").Edit;
    EtlTask := MObj As IEtlTask;
    EtlTask.PartialFetch := True;
    EtlTask.DefaultBlockSize := 300;
    MObj.Save;
End Sub UserProc;

After executing the example the number of records processed in one transaction is changed in the specified ETL task.

Fore.NET Example

The requirements and result of the Fore.NET example execution match with those in the Fore example.

Imports Prognoz.Platform.Interop.Etl;
…
Public Shared Sub Main(Params: StartParams);
Var
    MB: IMetabase;
    MObj: IMetabaseObject;
    EtlTask: IEtlTask;
Begin
    MB := Params.Metabase;
    MObj := MB.ItemById["T_ETL"].Edit();
    EtlTask := MObj As IEtlTask;
    EtlTask.PartialFetch := True;
    EtlTask.DefaultBlockSize := 300;
    MObj.Save();
End Sub;