Big Data Management User Guide

Back Next

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

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

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.

Click

Finish

Profiles

Download Guide