Working with Data Buffer Object

It acts as a buffer and does not pass any data to the next object until execution of the previous object completed successfully.

It can be used when you are validating very large file but you only want to load data only if file passes the validation or when you are loading data into multiple tables and want to load fact table last.

Validator aborted execution and no records were written by the writer.

Here is a part of the log

Information 27/06/2018 12:24:05 PM Preparing Writers…
Information 27/06/2018 12:24:05 PM Writer: {Writer3} Connection Type is: Text
Information 27/06/2018 12:24:05 PM Writer: {Writer3} Writer { Writer3 } Is Ready
Information 27/06/2018 12:24:05 PM All Writers are Ready
Information 27/06/2018 12:24:05 PM Target file: C:\DEMO\Buffer\result.csv
Information 27/06/2018 12:24:05 PM Processing Data…
Information 27/06/2018 12:24:05 PM Reader:{Reader} Connection Type is: Text
Information 27/06/2018 12:24:05 PM Reader:{Reader} Path: C:\DEMO\Text Files\
Information 27/06/2018 12:24:05 PM Reader:{Reader} Mask: Orders.csv
Information 27/06/2018 12:24:05 PM Reader:{Reader} Found: 1 files to read
Information 27/06/2018 12:24:05 PM Reader:{Reader} Reading all files
Information 27/06/2018 12:24:05 PM Reader:{Reader} Source File: C:\DEMO\Text Files\Orders.csv
Information 27/06/2018 12:24:05 PM 1 Data Buffer: Validation Reading Data Into the buffer
Information 27/06/2018 12:24:05 PM 1 Data Buffer: Validation Buffer size: 20,003
Error 27/06/2018 12:24:05 PM 1997 Is Equal To:{} Execution Aborted: Value of Field [ORDERNO] is 2000.
Execution Result of Function 'Is Equal To' is Success

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL forum

  • aetl/processing_data/working_with_databuffer.txt
  • Last modified: 27/06/2018 07:38
  • by admin