Package element: AGG - Get max value of EventSequence
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 |
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 |
See also