Table of Contents

Search

  1. Introduction to Data Discovery
  2. Data Discovery with Informatica Analyst
  3. Data Discovery with Informatica Developer
  4. Function Support Based on Profiling Warehouse Connection

Data Discovery Guide

Data Discovery Guide

Profile Export Results in Microsoft Excel

Profile Export Results in Microsoft Excel

When you export the complete profile results summary, the Analyst tool saves the information to multiple worksheets in a Microsoft Excel file. The Analyst tool saves the file in the "xlsx" format.
The following table describes the information that appears on each worksheet in the export file:
Tab
Description
Column Profile
Summary information exported from the summary view after the profile runs. Examples are column names, rule names, number of distinct values, number of null values, inferred data types, and date and time of the last profile run.
Values
Values for the columns and rules and the frequency in which the values appear for each column.
Patterns
Value patterns for the columns and rules you ran the profile on and the frequency in which the patterns appear.
Data Types
All the data types for the column, frequency of each data type, percentage value, and status of the data type, such as Inferred, Approved, or Rejected.
Statistics
Statistics about each column and rule. Examples are average, length, top values, bottom values, and standard deviation.
Properties
Properties view information, including profile name, type, sampling policy, and row count.

0 COMMENTS

We’d like to hear from you!