Stage File Activity : How to Read File in Segments using Stage File in Oracle Integration

Hi,
In this video we are going to learn how to read file in segments using stage file activity in oracle integration.
How to handle large file in oic?
How to read file more than 10 MB size in oracle integration?
How to read file in segments in oracle integration?
How to read file in segments using Stage activity in oracle integration?
Q-Limitation of Read Entire File using Stage File Activity in OIC.
Ans : Up to 10 MB
How to read large file in OIC?
Ans : Read File in Segments operation of Stage File Activity will help you to read large file up to 1 GB in OIC.
Stage File Operations in Oracle Integration.
1 Read Entire File
2 Read File in Segment
3 Write File
4 Zip Files
5 Unzip File
6 Encrypt File
7 Decrypt File
8 List Files
Join for more update:
WhatsApp:
chat.whatsapp....
Telegram:
t.me/oic_oracl...
#oic #OICintegration #integration #oraclecloud #oracleintegration #oracle #oracleoic #oralceintegrationcloud #lookup #lookupinoic #stagefile
#foxoic #foxOracleAppsSolutions #oictutorials

[@shivamwankhade6069]

I am getting full data in single line in payload. So please give the solution on this matter

[@foxoracleappssolutions]

you can split based on condition

[@MarioGDLMEX]

the batch size can be change? I mean instead of reading 200 records can we read 300 or even more? or this value cannot be set?

[@uday.sirivella]

Suppose i want to readfile segment with different schema at every time lets every time am reading different schema file from download directory how to do that

[@nofriken1298]

can this also read file edifact?

[@PA-jt2cq]

Is it possible to find out and remove duplicates from a file using OIC? if yes could you please let me know how to do this

[@foxoracleappssolutions]

it will required additional logic, which can be implemented through DB or by using XSLT group function.

[@abhishek-bb6vg]

can we read an XML file which more than 10 mb using Read file in segments?

[@foxoracleappssolutions]

Yes

[@abhishek-bb6vg]

@@foxoracleappssolutions I believe we can read only XSD and CSV files not the XML. Can you please verify this.

[@foxoracleappssolutions]

@@abhishek-bb6vg yes, we have to convert xml into xsd.