Scenario : JDBC to File
Requirement : PI fetches the data from Database and will send to multiple systems.
Problem : There are more than 60K Records in Database which size is around 100MB. When PI Pulls every thing at a time it will cause Memory Issue. On Receiver end Multiple systems will accept Only one file at a time, They Can not accept multiple files at a time.
Here the Problem is, How to append in to One Single file with Header details and send to Multiple Systems.
Kindly provide the Best Approach.
Thanks in Advance