Social Media Mappings
Create mappings to read social media data from sources such as Facebook and LinkedIn.
You can extract social media data and load them to a target in the native environment only. You can choose to parse this data or use the data for data mining and analysis.
To process or analyze the data in Hadoop, you must first move the data to a relational or flat file target and then run the mapping in the Hadoop cluster.
You can use the following Informatica adapters in the Developer tool:
- •PowerExchange for DataSift
- •PowerExchange for Facebook
- •PowerExchange for LinkedIn
- •PowerExchange for Twitter
- •PowerExchange for Web Content-Kapow Katalyst
Review the respective PowerExchange adapter documentation for more information.
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.