Hello Experts,
How to read large files - File Adapter Chunked Read not working in OSB!
I need to implement my Task only in OSB.
In my Usecase, I need to process a Large csv file (over 7 MB - with 70 K records in it) and insert the records into my Database. Since it is a huge file, I need to read it in Chunks of size 5000 records and then insert those into DB using DB Adapter.
I cannot implement File Adapter 'Read' operation and specify number of messages to process in batches, because there is no while loop activity in OSB to invoke Chunk read operation n number of time to read the complete file in chunks.
Also, how can I implement the invocation of a file adapter with chunk read in the pipeline flow?
Please provide your valuable suggestions as soon as possible as this is an urgent requirement.
Thanks and regards,
Deepam Jauhari