Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Big Data Management
  3. Mappings
  4. Sources
  5. Targets
  6. Transformations
  7. Data Preview
  8. Cluster Workflows
  9. Profiles
  10. Monitoring
  11. Hierarchical Data Processing
  12. Hierarchical Data Processing Configuration
  13. Hierarchical Data Processing with Schema Changes
  14. Intelligent Structure Models
  15. Stateful Computing
  16. Connections
  17. Data Type Reference
  18. Function 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:
QUERY=HypoBasket:)&since:2012-02-01
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 January 20, 2020