Creating Multiple Data Object Profiles
Multiple data object profiling operations use default column profiling options to generate column profiles for one or more data objects.
1. In the Object Explorer view, select the data objects you want to profile.
2. Click File > New > Profile to open the New Profilewizard.
3. Select the Multiple Profiles option and click Next.
4. Select the location where you want to create the profiles. You can create each profile at the same location as its profiled object, or you can specify a common location for the profiles.
5. Verify that the names of the data objects you selected appear within the Data Objects section.
Optionally, click Add to add another data object.
6. Optionally, specify the number of rows to profile, and choose whether to run the profile when the wizard completes.
7. Click Finish.
8. Optionally, enter prefix and suffix strings to add to the profile names.
9. Click OK.