Big Data Management User Guide

Back Next

Creating a Column Profile in Informatica Analyst

You can create a custom profile or default profile. When you create a custom profile, you can configure the columns, sample rows, and drill-down options. When you create a default profile, the column profile and data domain discovery runs on the entire data set with all the data domains.

In the

Discovery

workspace, click

Profile

, or select

New

Profile

from the header area.

You can right-click on the data object in the

Library

workspace and create a profile. In this profile, the profile name, location name, and data object are extracted from the data object properties. You can create a default profile or customize the settings to create a custom profile.

The

New Profile

wizard appears.

The

Single source

option is selected by default. Click

In the

Specify General Properties

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

In the

Select Source

screen, click

Choose

to select a data object, or click

New

to import a data object. Click

In the

Choose Data Object

dialog box, select a data object. Click

The Properties pane displays the properties of the selected data object. The Data Preview pane displays the columns in the data object.

In the

New Data Object

dialog box, you can choose a connection, schema, table, or view to create a profile on, select a location, and create a folder to import the data object. Click

In the

Select Source

screen, select the columns that you want to run a profile on. Optionally, select

Name

to select all the columns. Click

All the columns are selected by default. The Analyst tool lists column properties, such as the name, data type, precision, scale, nullable, and participates in the primary key for each column.

In the

Specify Settings

screen, choose to run a column profile, data domain discovery, or a column profile and data domain discovery. By default, column profile option is selected.

Choose

Run column profile

to run a column profile.

Choose

Run data domain discovery

to perform data domain discovery. In the

Data domain

pane, select the data domains that you want to discover, select a conformance criteria, and select the columns for data domain discovery in the

Edit columns selection for data domin discovery

dialog box.

Choose

Run column profile

and

Run data domain discovery

to run the column profile and data domain discovery. Select the data domain options in the

Data domain

pane.

By default, the columns that you select is for column profile and data domain discovery. Click

Edit

to select or deselect columns for data domain discovery.

Choose Data, Columns, or Data and Columns to run data domain discovery on.

Choose a sampling option. You can choose

All rows (complete analysis)

Sample first

Random sample

, or

Random sample (auto)

as a sampling option in the

Run profile on

pane. This option applies to column profile and data domain discovery.

Choose a drilldown option. You can choose

Live

Staged

drilldown option, or you can choose

Off

to disable drilldown in the

Drilldown

pane. Optionally, click

Select Columns

to select columns to drill down on. You can choose to omit data type and data domain inference for columns with an approved data type or data domain.

Choose

Native

Hive (deprecated)

, or

Hadoop

option as the run-time environment. If you choose the Hive or Hadoop option, click

Choose

to select a Hadoop connection in the

Select a Hadoop Connection

dialog box.

Click

The

Specify Rules and Filters

screen opens.

In the

Specify Rules and Filters

screen, you can perform the following tasks:

Create, edit, or delete a rule. You can apply existing rules to the profile.

Create, edit, or delete a filter.

When you create a scorecard on this profile, you can reuse the filters that you create for the profile.

Click

Save and Finish

to create the profile, or click

Save and Run

to create and run the profile.

Profiles

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Big Data Management User Guide

Big Data Management User Guide

Creating a Column Profile in Informatica Analyst

Creating a Column Profile in Informatica Analyst