File Size after Dataflow Merge or Aggregation
SummaryFile Size after Dataflow Merge or Aggregation
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.