Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Data Engineering Integration
  3. Mappings
  4. Mapping Optimization
  5. Sources
  6. Targets
  7. Transformations
  8. Python Transformation
  9. Data Preview
  10. Cluster Workflows
  11. Profiles
  12. Monitoring
  13. Hierarchical Data Processing
  14. Hierarchical Data Processing Configuration
  15. Hierarchical Data Processing with Schema Changes
  16. Intelligent Structure Models
  17. Blockchain
  18. Stateful Computing
  19. Appendix A: Connections Reference
  20. Appendix B: Data Type Reference
  21. Appendix C: 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 September 28, 2020