Table of Contents

Property NumberOfStagingTables

Namespace
YndigoBlue.Velocity.Data.Teradata
Assembly
YndigoBlue.Velocity.dll

NumberOfStagingTables

Gets or sets the number of staging tables used during import operations.

public int NumberOfStagingTables { get; set; }

Property Value

int

Remarks

During import operations, Velocity creates temporary staging tables to load and validate data before final insertion. This setting controls how many parallel staging tables are created, which affects import parallelism and performance.

Performance Impact:

  • Higher Values (8-16): More parallel staging tables allow concurrent data loading, significantly improving import throughput on multi-processor systems. Best for large imports on high-performance systems.
  • Default (4): Balanced approach suitable for most scenarios. Provides reasonable parallelism without excessive resource overhead.
  • Lower Values (1-2): Reduces parallelism and resource usage, slower imports. Use on resource-constrained systems or for small imports.

Tuning this value requires balancing import speed against system resources (CPU, memory, disk I/O).