Creating Multiple Data Object Profiles in Informatica Developer
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.
In the
Object Explorer
view, select the data objects you want to profile.
Click
File
New
Profile
to open the
New Profile
wizard.
In the
New
wizard, select the
Multiple Profiles
option, and click
Next
.
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.
Verify that the names of the data objects you selected appear within the
Data Objects
section.
Optionally, click
Add
to add another data object.
Optionally, specify the number of rows to profile, and choose whether to run the profile when the wizard completes.
Click
Next
.
In the
Validation Environment
section, choose
Native
.
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 data discovery profile. To run multiple data objects on the Databricks Spark in the Databricks run-tim environmnet, you can choose the enterprise data discovery profile.
Click
Finish
.
Optionally, enter prefix and suffix strings to add to the profile names.