to understand and define the contents of data flows and data stores, system builders use: This is a topic that many people are looking for. keralaplanningboard.org is a channel providing useful information about learning, life, digital marketing and online courses …. it will help you have an overview and solid multi-faceted knowledge . Today, keralaplanningboard.org would like to introduce to you SAP D&T Academy – How to Profile Data using SAP Information Steward – YouTube. Following along are instructions in the video below:
“My name is bill todd and i m a solution engineer with sa p. In in the following how to video you ll see how to profile data using s information stewart in the first step you ll see how to open up the workspace of a project then how to select the source and tables that you would like to profile next. You ll see how to select the type of profile that you d like to perform on the data followed by how to run the profile. Then finally how to view the results of your data profile.
When profiling data with s. Ap. Information stewart. You ll begin by going to the data.
Insight tab of the s. Ap..
Information stewart application from there. You ll see. The various projects that have been made available to you by your administrator. You ll start by selecting the project that you would like to profile data with and click on the workspace button for that project when you click on the workspace.
What you ll see are the various data sources that have been added to the project you can always add new data sources by clicking on the add data source button located at the top. What s a data source has been added it s very easy to profile. It you can do so by going to the data source expanding it to see in this case the tables that are available if it was a flat file data source you can expand the folder for the flat file and see the various files that are available to profile in order to profile. The data source.
All you would do is check the box next to that data source in this case. I m checking the box next to the product table..
That s in the sales application database. Then we ll click on the profile button located at the top. There are various choices for the types of profiles that you d like to do in this case. We re going to profile the columns that are in this table.
So we ll select columns next. We ll select what type of profiling. We d like to do for these columns. A simple profile to pring back simple results or a median and distribution profile to bring back more results around the distribution of values in the various fields.
You can also select a word distribution to bring back results about the various words contained in the fields in this case. We re going to do both simple and the meeting and distribution will give this profile a name and then we ll click save and run now once we ve run the profile..
The results will show up next to the table. We can view the results by expanding the table. And then seeing the various data profile results that have been returned by information steward. There are profile results around minimum and maximum value average values the median minimum and maximum string length and the average and median for string lis.
It also returns profile results for completeness of the data and distribution for the various fields. One of the more commonly used data profile results is the values that are returned by a data distribution in this case. We ll select one of the fields and we ll click on the values when we click on the number 10. We can see the ten values distinct values.
That is that are found in this color column inside of the product table for all these results. We could always click on them to see..
Examples of records that have this value in the color field. And those results show up right down here now finally if we d like to export the results of this profile. We can click the export to excel button to export this data that we re looking at to excel also if we d like to export the entire profile results for the table. We can do so by selecting the button up at the top here and click export profile results to export.
All the various profile attributes for the columns to an excel spreadsheet so what we ve seen in this how to video is how to profile data using s. Ap information stewart. ” ..
Thank you for watching all the articles on the topic SAP D&T Academy – How to Profile Data using SAP Information Steward – YouTube. All shares of keralaplanningboard.org are very good. We hope you are satisfied with the article. For any questions, please leave a comment below. Hopefully you guys support our website even more.
This video will walk you step-by-step through the process to profile data using SAP Information Steward so that you can perform this process on your system. This video is part of the SAP Database u0026 Technology Academy.
EIM, SAP, SAPD&TAcademy, SAPDatabase&Technology, InformationSteward, profiledata