Table of Contents

Search

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

Getting Started Guide

Getting Started Guide

Parsing Data Summary

Parsing Data Summary

In this lesson, you learned that parsing data identifies the data elements in an input field and writes each element to a new column.
You learned that you use the Parser transformation to parse data. You also learned that you can create a profile for a transformation in a mapping to analyze the output from that transformation. Finally, you learned that you can view mapping output using the Data Viewer.
You created and configured the
LA_Customers_tgt
data object to contain parsed output. You created a mapping to parse the data. In this mapping, you configured a Parser transformation with a token set to parse first names and last names from the
FullName
column in the Los Angeles customer file. You configured the mapping to write the parsed data to the
Firstname
and
Lastname
columns in the
LA_Customers_tgt
data object. You also ran a profile to view the output of the transformation before you ran the mapping. Finally, you ran the mapping and used the Data Viewer to view the new data columns in the
LA_Customers_tgt
data object.

0 COMMENTS

We’d like to hear from you!