Announcement Announcement Module
No announcement yet.
Validating logically related files and processing together Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • Validating logically related files and processing together

    I have two files header and detail file. I would like to logically process these together. One of the requirements we have is to validate the amount field in header with the sum of detail amounts and also verify the count in header to detail records count for a specific batch number and then only process the file to database tables.
    I tried using multi resource file reader but it processes it sequentially one file after other and also it is chunk processed so I am not sure how would I satisfy the above said requirements.

    One of the ideas that I have to put in the execution context map with key(header) with value(detail info) and keep updating details info in the writer as we go and then once the steps complete have after step listener inspect the map for matching amount and line count.

    Any kind of other idea or suggestion will be highly appreciated.

    Let me know if you need more information

    Thank You