What is the meaning of Batch Size in Sequence Generator transformation where a sequence is generated in a Database Table?¶
The Batch Size determines the length of a sequence. If a dataset contains 300 records, and the Batch Size is set to 100, the sequence will repeat thrice since it will generate only 100 unique values and then repeat that sequence.