Creating a Single Data Object Profile in Informatica Developer
Creating a Single Data Object Profile in Informatica Developer
You can create a single data object profile for one or more columns in a data object and store the profile object in the Model repository.
In the
Object Explorer
view, select the data object you want to profile.
Click
File
New
Profile
to open the profile wizard.
Select
Profile
and click
Next
.
Enter a name for the profile and verify the project location. If required, browse to a new location.
Optionally, enter a text description of the profile.
Verify that the name of the data object you selected appears in the
Data Objects
section.
Click
Next
.
Configure the profile operations that you want to perform. You can configure the following operations:
Column profiling
Primary key discovery
Functional dependency discovery
Data domain discovery
To enable a profile operation, select
Enabled as part of the "Run Profile" action
for that operation. Column profiling is enabled by default.
Review the options for your profile.
You can edit the column selection for all profile types. Review the filter and sampling options for column profiles. You can review the inference options for primary key, functional dependency, and data domain discovery. You can also review data domain selection for data domain discovery.
Review the drill-down options, and edit them if necessary. By default, the
Enable Row Drilldown
option is selected. You can edit drill-down options for column profiles. The options also determine whether drill-down operations read from the data source or from staged data, and whether the profile stores result data from previous profile runs.
In the
Run Settings
section, choose a run-time environment. Choose
Native
,
Hive (deprecated)
, or
Hadoop
as the run-time environment. When you choose the Hive or Hadoop option, select a Hadoop connection.