Skip to main content

Blocking Step

Description

Blocking Step holds all incoming rows until the previous step finishes processing its last row. At that point, it either passes all accumulated rows to the next step or passes none, depending on configuration. Use this step when you need to synchronize data flow — for example, to ensure all rows are available before a stored procedure, a JavaScript step, or another operation that requires the complete dataset. When passing all rows, it can use a spool directory and compression to manage memory for large datasets.

Configurations

Field NameDescription
Step nameSpecify a name for the step; this name has to be unique in a single workflow.
Pass all rows?This checkbox determines whether to pass no row or all rows. If this is checked the following fields are enabled.
Spool directorySpecify the directory in which the temporary files are stored if needed; the default is the standard temporary directory for the system
Spool-file prefixSpecify a recognizable prefix to identify the files when they appear in the temp directory
Cache sizeSpecify a cache size for rows in memory. The more rows you can store in memory, the faster the step works
Compress spool files?Enable this checkbox to compresses temporary files.