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.