Part I: Getting Started with Informatica Analyst > Lesson 3. Creating Quick Profiles > Task 1. Create and Run a Quick Profile
  

Task 1. Create and Run a Quick Profile

In this task, you create a quick profile for all columns in the data object and use default sampling and drilldown options.
    1. Click New > Data Object Profile.
    The New Profile wizard appears in the Discovery workspace. The Column profiling option is selected by default.
    2. Click Next.
    3. In the Sources section, navigate to LA_Customers.
    4. Select the check box next to LA_Customers.
    5. Click Save & Run to create and run the profile.
    The Analyst tool creates the profile and the profile results appear in the Discovery workspace.

Column Profile Results

The column profile results include name, unique values, null values, and data types.
The following table describes the information that appears for each column in a profile:
Property
Description
Name
Name of the column in the profile.
Unique Values
Number of unique values in the column.
% Unique
Percentage of unique values in the column.
NULL
Number of null values in the column.
% Null
Percentage of column values that are null.
Datatype
Data type derived from the values in the column. The Analyst tool can derive the following data types from the column values:
  • - String
  • - Varchar
  • - Decimal
  • - Integer
  • - Null [-]
% Inferred
Percentage of values that match the data type inferred by the Analyst tool.
Documented Datatype
Data type declared for the column in the profiled object.
Minimum Value
Minimum value in the column.
Maximum Value
Maximum value in the column.
Last Profile Run
Date and time you last ran the profile.
Drilldown
If selected, enables drilldown on live data for the column.