Table of Contents

Search

  1. Preface
  2. Introduction to Reference Data
  3. Reference Tables in the Analyst Tool
  4. Reference Data in the Developer Tool
  5. Classifier Models
  6. Probabilistic Models
  7. Appendix A: Reference Data and Informatica Data Engineering Integration

Reference Data Guide

Reference Data Guide

Labeler Transformation Example

Labeler Transformation Example

The customer database at an insurance organization contains multiple data entry errors. You are a data steward at the insurance organization. You configure a mapping with a Labeler transformation to determine the different types of data that each column contains.
The following table describes sample data from the customer database:
Row ID
Field 1
Field 2
Field 3
1
19132954
AIM SECURITIES
PETRIE TAYBRO
2
10110169
JASE TRAPANI
BANK OF NEW YORK
3
10111786
WANGER ASSET MANAGEMENT, LLP
JAN SEEDORF
4
10112299
FELIX LEVENGER
HARVARD MAGAZINE
5
10112036
DESCHÊNES & FILS LTÉE (QUEBEC)
RICHARD TREMBLAY
6
BERGER ASSOCIATES
10111101
DAREEN HULSMAN
7
19131385
EAGLE FINANCIAL GROUP INC
PATRICK MCKINNIE
8
LAKENYA PASKETT
WHITEHALL FINANCIAL GROUP
15954710
When you run the mapping, the Labeler transformation compares the input data with the probabilistic model reference data. The Labeler transformation selects a label for the data on each input port. The transformation writes the labels to an output port. Each output row contains a set of labels that defines the data structure on the corresponding input row.
The following table describes the labels that the Labeler transformation adds to the output port:
Row ID
Output Labels
1
number organization contact
2
number contact organization
3
number organization contact
4
number contact organization
5
number organization contact
6
organization number contact
7
organization number contact
8
contact organization number

0 COMMENTS

We’d like to hear from you!