SSIS:Profiler:Analysis Options - Revision history

Admin at 00:32, 14 November 2015

2015-11-14T00:32:53Z

← Older revision		Revision as of 00:32, 14 November 2015
Line 1:		Line 1:
	~~[[SSIS:Reference\|← SSIS Reference]]~~		{{SSISProfilerNav

	{{ SSISProfilerNav
	\|ProfilerTabsCollapse=		\|ProfilerTabsCollapse=
	}}		}}

Admin at 19:34, 10 February 2015

2015-02-10T19:34:40Z

← Older revision		Revision as of 19:34, 10 February 2015
Line 24:		Line 24:
	;Data Aggregation		;Data Aggregation
	:This is an analysis of aggregate data determination (e.g., averages, median, quartiles, etc.). This enables/disables all forms of aggregation and value gathering. Any statistic that cannot be determined incrementally (for example, median, population standard deviation, etc.) is determined via aggregation. This analysis is also responsible for all value tables (Frequency, Pattern, SoundEx, etc.). All iterators and data aggregation statistics are dependent on this analysis. This increases profiling time by over 90%.		:This is an analysis of aggregate data determination (e.g., averages, median, quartiles, etc.). This enables/disables all forms of aggregation and value gathering. Any statistic that cannot be determined incrementally (for example, median, population standard deviation, etc.) is determined via aggregation. This analysis is also responsible for all value tables (Frequency, Pattern, SoundEx, etc.). All iterators and data aggregation statistics are dependent on this analysis. This increases profiling time by over 90%.

	~~;Count Generation~~
	~~:This is an analysis of basic count calculation.~~

Admin at 23:48, 9 February 2015

2015-02-09T23:48:29Z

← Older revision		Revision as of 23:48, 9 February 2015
Line 4:		Line 4:
	\|ProfilerTabsCollapse=		\|ProfilerTabsCollapse=
	}}		}}


	{{CustomTOC}}		{{CustomTOC}}

Admin at 23:47, 9 February 2015

2015-02-09T23:47:59Z

@@ Line 1: / Line 1: @@
 [[SSIS:Reference|&larr; SSIS Reference]]
-{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
+{{ SSISProfilerNav
-! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''Profiler Navigation'''
+|ProfilerTabsCollapse=
-|-
+}}
 {{CustomTOC}}

Admin at 20:10, 9 February 2015

2015-02-09T20:10:41Z

← Older revision		Revision as of 20:10, 9 February 2015
Line 38:		Line 38:
	{{CustomTOC}}		{{CustomTOC}}

	~~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~~.		The Analysis Options tab allows for enabling/disabling certain profiling calculations. Disabling unused Analysis Options will become beneficial due to the increase in processing time.

	[[file:SSIS_PF_AnalysisOptions.png\|link=]]		[[file:SSIS_PF_AnalysisOptions.png\|link=]]
Line 44:		Line 44:
	==Analysis Options==		==Analysis Options==
	;Sort Analysis		;Sort Analysis
	:This is an analysis of any prevailing sortation for each profiled column.		:This is an analysis of any prevailing sortation for each profiled column. This enables/disables the sortation analysis, which can increase profiling time. This time penalty grows geometrically as more records are added. If you are not interested in this statistic, disable it to decrease your profiling time.

	;MatchUp Analysis		;MatchUp Analysis
	:This is an analysis of duplicate record detection.		:This is an analysis of duplicate record detection. This enables/disables duplicate record detection. Duplicate analysis increases the profiling time by under 5% and ProfileData profiling time by about 30%.

	;RightFielder Analysis		;RightFielder Analysis
	:This is an analysis of profiled columns' inferred data type (e.g., Full Name, Address, etc.).		:This is an analysis of profiled columns' inferred data type (e.g., Full Name, Address, etc.). This enables/disables inferred data type analysis. This analysis is responsible for the Inconsistent Data and Inferred Data Type statistics. This increases the profiling time by under 10%.

	;Data Aggregation		;Data Aggregation
	:This is an analysis of aggregate data determination (e.g., averages, median, quartiles, etc.).		:This is an analysis of aggregate data determination (e.g., averages, median, quartiles, etc.). This enables/disables all forms of aggregation and value gathering. Any statistic that cannot be determined incrementally (for example, median, population standard deviation, etc.) is determined via aggregation. This analysis is also responsible for all value tables (Frequency, Pattern, SoundEx, etc.). All iterators and data aggregation statistics are dependent on this analysis. This increases profiling time by over 90%.

	;Count Generation		;Count Generation
Line 60:		Line 60:

	==Setup Options==		==Setup Options==
	~~These options~~ are purely for documentation~~. They~~ have no impact on profiling results.		The Setup Options are not required. They are used purely for documentation purposes and will have no impact on profiling results.

			;Table Name
			:This function sets the user name for a particular run.

			;User Name
			:This function sets the user name for a particular run.

			;Job Name
			:This function sets the job name for a particular run.

			;Job Description
			:This function sets the job description for a particular run.


	[[Category:SSIS]]		[[Category:SSIS]]
	[[Category:SSIS Profiler]]		[[Category:SSIS Profiler]]

Admin: Created page with "← SSIS Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; pa..."

2015-01-16T22:01:44Z

Created page with "← SSIS Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; pa..."

New page

[[SSIS:Reference|← SSIS Reference]]

{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''Profiler Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[SSIS:Profiler|Overview]]
|-
|[[SSIS:Profiler Tutorial|Tutorial]]
|-
|[[SSIS:Profiler:Advanced Configuration|Advanced Configuration]]
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|Profiler Tabs
|-
|[[SSIS:Profiler:Input Field|Input Field]]
|-
|[[SSIS:Profiler:Analysis Options|Analysis Options]]
|-
|[[SSIS:Profiler:Output|Output]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:Profiler:Result Codes|Result Codes]]
|-
|[[Returned Result Codes:Enterprise Solutions#Data Quality Components for SSIS|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}

{{CustomTOC}}

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.

[[file:SSIS_PF_AnalysisOptions.png|link=]]

==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.

[[Category:SSIS]]
[[Category:SSIS Profiler]]