Package element: AGG - Get max value of EventSequence

CollapseAll image

Collapse image Properties


 Name   Value 
AreInputColumnsValid True
ComponentClassID {C0FF41D9-3C8A-479F-A931-ECF1BF3587AB}
ContactInfo Aggregate;Microsoft Corporation;Microsoft SqlServer 2015; (C) 2014 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;3
Description Aggregates and groups values in a dataset.
ID 2
IdentificationString AGG - Get max value of EventSequence
IsDefaultLocale True
LocaleID English (United States)
Name AGG - Get max value of EventSequence
ObjectType 12
PipelineVersion 0
UsesDispositions False
ValidateExternalMetadata True
Version 3

Collapse image Elements


 Name   Description   Type 
KeyScale Specifies the approximate number of group by keys that the aggregation produces. Low indicates 500,000 key values, Medium indicates 5 million key values, and High indicates more than 25 million key values. Unspecified indicates no KeyScale value is used. CustomPropertyCollection
Keys Specifies the exact number of group by keys that the aggregation produces. If a KeyScale value is specified, the value in Keys takes precedence. CustomPropertyCollection
CountDistinctScale Specifies the approximate number of distinct values in a column that the aggregation counts distinctly. Low indicates 500,000 key values, Medium indicates 5 million key values, and High indicates more than 25 million key values. Unspecified indicates no CountDistinctScale value is used. CustomPropertyCollection
CountDistinctKeys Specifies the exact number of distinct values in a column that the aggregation counts distinctly. If a CountDistinctScale value is specified, the value in CountDistinctKeys takes precedence. CustomPropertyCollection
AutoExtendFactor Specifies the percentage by which memory can be extended during the aggregation. Valid values are between 1 and 100. CustomPropertyCollection
Aggregate Input 1   InputCollection
Aggregate Output 1   OutputCollection

Collapse image See also


Package index