OIC - How to read file size up to 1 GB in oracle integratio

By default, we can only read 10 MB file. To read a file size upto 1GB file we have to follow the below steps:

Steps:

1. List the files using FTP connection
2. Loop the list of files using For Each action
3. Download the each file into a stage (VFS) location.
4. Read file records in chunk using read in segments. Each record contains 200 records.
5. Read the file using a sample csv file format.

Screenshots:

List files using FTP connection

Download the file using FTP connection

Take a For each and loop each file

Map each file from list response to download request

Read file in segments