Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Profiles
  3. Part 2: Profiling with Informatica Analyst
  4. Part 3: Profiling with Informatica Developer

Profile Guide

Profile Guide

Sampling Options

Sampling Options

Configure the sampling options to determine the number of rows that the profile reads during a profiling operation.
The following table describes the sampling options:
Property
Description
All Rows
Chooses all rows in the data object.
First
The number of rows that you want to run the profile against. The Developer tool chooses the rows from the first rows in the source. You can choose a maximum of 2,147,483,647 rows.
Random Sample of
The random sample algorithm chooses the rows at random in the data object to run the profile on. You can choose a maximum of 2,147,483,647 rows.
Random Sample (Auto)
Random sample size is computed based on the number of rows in the data object.
Exclude approved data types and data domains from the data type and data domain inference in the subsequent profile runs
Excludes the approved data type or data domain from data type and data domain inference from the next profile run.
After you choose to run the profile on a random sample of rows, the random sample algorithm chooses the rows at random in the data object to run the profile on. When you choose a random sampling option for column profiles, the Developer tool performs drilldown on the staged data. This can impact the drill-down performance. When you choose a random sampling option for data domain discovery profiles, the Developer tool performs drill down on live data.

0 COMMENTS

We’d like to hear from you!