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

Profiling Data Summary

Profiling Data Summary

In this lesson, you learned that a profile provides information about the content and structure of the data.
You learned that you can perform a join analysis on two data objects and view the degree of overlap between the data objects. You also learned that you can run a column profile on a data object and view values, patterns, and statistics that relate to each column in the data object.
You created the
JoinAnalysis
profile to determine whether data from the
Boston_Customers
data object can merge with the data in the
LA_Customers
data object. You viewed the results of this profile and determined that all values in the
CustomerID
column are unique and that you can merge the data objects successfully.
You created the
All_Customers
profile and ran a column profile on the
All_Customers
data object. You viewed the results of this profile to discover values, patterns, and statistics for columns in the
All_Customers
data object. Finally, you ran the Data Viewer to view rows containing values and patterns that you selected, enabling you to verify the quality of the data.

0 COMMENTS

We’d like to hear from you!