SSIS:Profiler:Analysis Options
Revision as of 22:01, 16 January 2015 by Admin (talk | contribs) (Created page with "← SSIS Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; pa...")
| Profiler Navigation | ||||
|---|---|---|---|---|
| Overview | ||||
| Tutorial | ||||
| Advanced Configuration | ||||
| ||||
|
These options analyze a table's data to provide a large number of statistics at varying levels of detail. Analysis Options can have a significant impact on the processing speed. For faster processing, turn off any unnedded options.
Analysis Options
- Sort Analysis
- This is an analysis of any prevailing sortation for each profiled column.
- MatchUp Analysis
- This is an analysis of duplicate record detection.
- RightFielder Analysis
- This is an analysis of profiled columns' inferred data type (e.g., Full Name, Address, etc.).
- Data Aggregation
- This is an analysis of aggregate data determination (e.g., averages, median, quartiles, etc.).
- Count Generation
- This is an analysis of basic count calculation.
Setup Options
These options are purely for documentation. They have no impact on profiling results.