Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

File Size after Dataflow Merge or Aggregation

Question
11
Views
0
Comments
Jackie Dunn
Jackie Dunn Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Summary

File Size after Dataflow Merge or Aggregation

Content

I have been testing some data with both the MERGE functionality (union all option) and also a simple aggregation of all columns by 1 agg field.  In each test case, the new dataset file size was exponentially larger than the original dataset - 80MB to 200MB as an example.  Logically it would seem that the new dataset would be smaller - there were no other steps in the dataflow....Any insight into why this is occurring would be greatly appreciated.