Skip to Content
0
May 18, 2016 at 08:45 AM

JDBC to File Scenario

34 Views

Dear Experts,

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