Using Aggregate Functions Sum(), Count() while Processing Larger Files by Phaneendra Bommisetty
May 18, 2021 Leave a comment
Introduction:
OIC has the capability of processing huge CSV files (up to 1GB) using Stage "Read File In Segments" activity. In some use-cases, customers require to calculate the sum of a column or count of rows.
Consider the following payload. Say, we want to calculate the sum of all the values in the column "Amount1". Customers tend to declare a variable upstream to Stage action and keep on updating this variable with the computation done in each chunk of the Stage.
Solution:
This blog describes one of the optimal approaches to use the aggregate functions Sum, Count while processing larger files. Read the complete article here.
For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.
Blog 
Twitter 
LinkedIn ![image[7][2][2][2]](https://soacommunity.files.wordpress.com/2013/04/image7222.png?w=20&h=20 "image[7][2][2][2]"){kind=small}
Facebook ![clip_image002[8][4][2][2][2]](https://soacommunity.files.wordpress.com/2013/04/clip_image00284222.jpg?w=26&h=23 "clip_image002[8][4][2][2][2]"){kind=small}
Wiki
Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress
About Jürgen Kress
PaaS Community Blog 