Use the Flush Buffer option to write out the buffered rows to the
target.
All components for which a write block size has been specified
can buffer data until the write block size is reached. At any time
during simulation, if there is data in the buffer, the Flush Buffer
option appears, along with the number of rows that are yet to be
written to the target. If the buffer is empty, the option is not
available.
Right-click the DB Data Sink Update component
and select Flush Buffer.