The ASO data load buffer properties, which specify how to handle empty source data values, can be specified as follows:

• ignore_missing_values: Ignore missing values in the source data.

• ignore_zero_values: Ignore zeros in the source data.

• aggregate_use_last: Combine duplicate cells by using the value of the cell that was loaded last into the data load buffer. When using this option, data loads are significantly slower, even if there are not any duplicate values.

  Caution:

  The aggregate_use_last method has significant performance impact, and is not intended for large data loads. If your data load is larger than one million cells, consider separating the numeric data into a separate data load process (from any typed measure data). The separate data load can use aggregate_sum instead.

• aggregate_sum: (Default) Add values when the buffer contains multiple values for the same cell.

If you use multiple properties and any conflict occurs, the last property listed takes precedence.

Type

string (see MaxL Syntax Notes)

Referenced By

alter database (aggregate storage)