Table of Contents


  1. Preface
  2. Introduction to Informatica Big Data Management
  3. Connections
  4. Mappings in a Hadoop Environment
  5. Mapping Objects in a Hadoop Environment
  6. Mappings in the Native Environment
  7. Profiles
  8. Native Environment Optimization
  9. Data Type Reference
  10. Function Reference
  11. Parameter Reference

Twitter Mapping Example

Twitter Mapping Example

Your organization, Hypomarket Corporation, needs to review all the tweets that mention your product HypoBasket with a positive attitude since the time you released the product in February 2012.
Create a mapping that identifies tweets that contain the word HypoBasket and writes those records to a table.
You can use the following objects in a Twitter mapping:
Twitter input
The mapping source is a Twitter data object that contains the resource Search.
Create a physical data object and add the data object to the mapping. Add the Search resource to the physical data object. Modify the query parameter with the following query:
Sorter transformation
Optionally, sort the data based on the timestamp.
Add a Sorter transformation to the mapping. Specify the timestamp as the sort key with direction as ascending.
Mapping output
Add a relational data object to the mapping as a target.
After you run the mapping, Data Integration Service writes the extracted tweets to the target table. You can use text analytics and sentiment analysis tools to analyze the tweets.

Updated July 03, 2018