Export (0) Print
Expand All

Aggregate Transformation Editor (Advanced Tab)

Use the Advanced tab of the Aggregate Transformation Editor dialog box to set component properties, specify aggregations, and set properties of input and output columns.

Note Note

The options for key count, key scale, distinct key count, and distinct key scale apply at the component level when specified on the Advanced tab, at the output level when specified in the advanced display of the Aggregations tab, and at the column level when specified in the column list at the bottom of the Aggregations tab.

In the Aggregate transformation, Keys and Keys scale refer to the number of groups that are expected to result from a Group by operation. Count distinct keys and Count distinct scale refer to the number of distinct values that are expected to result from a Distinct count operation.

To learn more about the Aggregate transformation, see Aggregate Transformation.

Keys scale

Optionally specify the approximate number of keys that the aggregation expects. The transformation uses this information to optimize its initial cache size. By default, the value of this option is Unspecified. If both Keys scale and Number of keys are specified, Number of keys takes precedence.

Value

Description

Unspecified

The Keys scale property is not used.

Low

Aggregation can write approximately 500,000 keys.

Medium

Aggregation can write approximately 5,000,000 keys.

High

Aggregation can write more than 25,000,000 keys.

Number of keys

Optionally specify the exact number of keys that the aggregation expects. The transformation uses this information to optimize its initial cache size. If both Keys scale and Number of keys are specified, Number of keys takes precedence.

Count distinct scale

Optionally specify the approximate number of distinct values that the aggregation can write. By default, the value of this option is Unspecified. If both Count distinct scale and Count distinct keys are specified, Count distinct keys takes precedence.

Value

Description

Unspecified

The CountDistinctScale property is not used.

Low

Aggregation can write approximately 500,000 distinct values.

Medium

Aggregation can write approximately 5,000,000 distinct values.

High

Aggregation can write more than 25,000,000 distinct values.

Count distinct keys

Optionally specify the exact number of distinct values that the aggregation can write. If both Count distinct scale and Count distinct keys are specified, Count distinct keys takes precedence.

Auto extend factor

Use a value between 1 and 100 to specify the percentage by which memory can be extended during the aggregation. By default, the value of this option is 25%.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft