Creating Multiple Data Object Profiles in Informatica Developer
When you run the multiple data object profile on multiple data objects, the Developer tool uses the default column profiling options to generate column profiles for one or more data objects. Optionally, you can create an enterprise discovery profile to run a profile on multiple 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. In the New wizard, select the Multiple Profiles option, and click Next.
4. In the Multiple Profiles window, 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 Next.
8. In the Validation Environment section, choose Native.
Note: Choose only the Native option to run the multiple data object profile. To run multiple data objects on the Blaze or Spark engine in the Hadoop run-time environment, you can choose the enterprise discovery profile.
9. Click Finish.
10. Optionally, enter prefix and suffix strings to add to the profile names.
11. Click OK.