SSIS:Profiler:Analysis Options
| 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.