Table of Contents

Search

  1. Preface
  2. Getting Started Overview
  3. Part 1: Getting Started with Informatica Analyst
  4. Part 2: Getting Started with Informatica Developer
  5. Appendix A: Frequently Asked Questions

Data Quality Getting Started Guide

Data Quality Getting Started Guide

Creating Custom Profiles Overview

Creating Custom Profiles Overview

A profile is the analysis of data quality based on the content and structure of data. A custom profile is a profile that you create when you want to configure the columns, sampling options, and drilldown options for faster profiling. Configure sampling options to select the sample rows in the source. Configure drilldown options to drill down to data rows in the source data or staged data. You can choose to run the profile in a Hadoop or native environment.
You create and run a profile to analyze the quality of the data when you start a data quality project. When you create a profile object, you start by selecting the data object and data object columns that you want to run a profile on.

Story

HypoStores needs to incorporate data from the newly-acquired Los Angeles office into its data warehouse. HypoStores wants to access the quality of the customer tier data in the LA customer data file. You are the analyst responsible for assessing the quality of the data and passing the information on to the developer responsible for cleansing the data.

Objectives

In this lesson, you complete the following tasks:
  1. Create a custom profile for the flat file data object and exclude the columns with null values.
  2. Run the profile to analyze the content and structure of the CustomerTier column.
  3. Drill down into the rows for the profile results.

Prerequisites

Before you start this lesson, verify the following prerequisite:
  • You have completed lessons 1, 2, and 3 in this tutorial.

Timing

Set aside 5 to 10 minutes to complete this lesson.

0 COMMENTS

We’d like to hear from you!