User Guide

10.2.2 Service Pack 1
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0
- 10.2.2 HotFix 1
- 10.2.2
- 10.2.1

Back Next

Creating an Enterprise Discovery Profile in Informatica Analyst

You can run column profile and data domain discovery as part of enterprise discovery in Informatica Analyst.

In the

Discovery

workspace, select

New

Profile

The

New Profile

wizard appears.

Select

Enterprise Discovery

. Click

The

Specify General Properties

tab appears.

In the

Specify General Properties

tab, enter a name for the enterprise discovery profile and an optional description. In the Location field, select the project or folder where you want to create the profile. Click

The

Select Data Objects

tab appears.

In the

Select Data Objects

tab, click

Choose

The

Choose Data objects

dialog box appears.

In the

Choose Data objects

dialog box, choose one or more data objects to add to the profile. Click

Save

The data objects appear in the

Data Objects

pane.

Click

The

Select Resources

tab appears.

In the

Select Resources

tab, click

Choose

to open the

Select Resources

tab.

You can import data from multiple relational data sources.

In the

Select Resources

tab, select the connections, schemas, tables, and views that you want to include in the profile. Click

Save

The left pane in the dialog box lists all the internal and external connections, schemas, tables, and views under the Informatica domain.

The resources appear in the

Resource

pane.

Click

The

Specify Settings

tab appears.

In the

Specify Settings

tab, you can configure the column profile options and data domain discovery options. Click

Save and Finish

to save the enterprise discovery profile, or click

Save and Run

to run the profile.

You can perform the following tasks in the

Specify Settings

tab.

Enable data domain discovery. Click

Choose

to select data domains that you want to discover from the

Choose Data Domains

dialog box. The selected data domains appear in the

Data Domains for Data Domain Discovery

pane.

Run data domain on data, column name, or on both data and column name.

Select all the rows in the data source, or choose a maximum number of rows to run domain discovery on.

Choose a minimum conformance percentage or specify the minimum number of conforming rows for data domain discovery.

Enable column profile settings and select all rows or first few rows in the data source for the column profile. You can exclude data type inference for columns with approved data types in the column profile.

Choose

Native

Hadoop

as the run-time environment.

You can view the enterprise discovery results under the

Summary

and

Profiles

tabs.

Profiles

Download Guide

Watch