Data Profile Viewer
Types of Data Profiles
Right-click the Data Profiling task in the SSIS Designer, and then click Edit. Click Profile Viewer on the General page of the Data Profiling Task Editor.The viewer uses many panes to display the profiles. that you requested and the computed results, with optional details and drill down capability.
Profiles paneThe Profiles pane displays the profiles that requested in the Data Profile task. To view the computed results for the profile, select the profile in the Profiles pane. the results will appear in the other panes of the viewer.
Results paneThe Results pane uses a summarize the computed results of the profile. if request a Column Length Distribution Profile. this row includes the small and largest length, and the row count. For most profiles select this row in the Results pane to see more detail in the optional.
Details pane.The Details pane For most profile types, the Details pane displays extra information. the profile results selected in the Results pane. if request a Column Length Distribution Profile. the Details pane displays each column length found. The pane also displays the number and percentage of rows. which the column value has that column length. For the three profile types competed against more than one column. the Details pane displays of the expected relationship. if request a Candidate Key Profile, the Details pane displays duplicate values. that violate the uniqueness of the candidate key.If the data source used to compute the profile is available. the double-click a row in the Details pane to see the matching rows of data in the Drilldown pane.
Drill down paneThe double-click a row Details pane to see the matching rows of data in the Drilldown pane. when the following conditions are true
The data source used to compute the profile is available.
permission to view the data. To connect to the source database for a drill down the request. the Data Profile Viewer uses Windows Authentication credentials of the current user. The Data Profile Viewer does not use the connection information. that stored in the package that ran the Data Profiling task.
Types of Data Profiles MSBI training in Hyderabad: We provide Types of Data Profiles MSBI training in Hyderabad by real time experts in the Online project.