Part III: Data Discovery with Informatica Developer > Data Object Profiles > Data Object Profiles Overview
  

Data Object Profiles Overview

A data object profile discovers information about the column data and metadata in a data source. You can run a profile on a single data object and multiple data objects in the Developer tool. A single data object profile analyzes one data source. Multiple data object profiles analyze more than one data source. When you create multiple data object profiles, you can run a column profile on them.
The following table describes the data discovery tasks that you can perform for a single data object profile:
Task
Description
Column profiling
Discovers the characteristics of data, such as frequencies, percentages, and patterns. You can add filters to determine the rows that the profile reads at run time. The profile does not process rows that do not meet the filter criteria.
Primary Key Discovery
Discovers columns with values that can uniquely identify the rows in a data source.
Functional Dependency Discovery
Discovers dependencies between pairs of columns in a data source.
Data Domain Discovery
Identifies all the data domains for a column based either on the column value or column name.
The following table describes the data discovery tasks that you can perform on multiple data objects when you create a data model using the Enterprise Discovery Profile option:
Task
Description
Foreign Key Discovery
Discovers columns that have values that match the primary key values in another data source.
Join Analysis
Discovers the degree of potential joins between the data in two columns in a data source or between two data sources.
Overlap Discovery
Discovers the percentage of overlapping data between pairs of columns in a data source or multiple data sources.
Enterprise Discovery
Discovers column profile statistics, data domains, primary keys, and foreign keys in a large number of data sources spread across multiple connections or schemas.