Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • PowerExchange Adapters for Informatica 10.4.0
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Twitter
  3. PowerExchange for Twitter Configuration
  4. Twitter and Twitter Streaming Connections
  5. Twitter and Twitter Streaming Data Objects
  6. Twitter Mappings
  7. Datatype Reference

PowerExchange for Twitter User Guide

PowerExchange for Twitter User Guide

Back Next

Twitter Data Object Operation Properties

Twitter Data Object Operation Properties

The data object operation properties include general, ports, sources, and advanced properties that the Data Integration Service uses to read data from Twitter.

General Properties

The general properties lists the name and description of the data object operation.
The following table describes the general properties that you can view for a Twitter data object operation:
Property
Description
Name
Name of the Twitter data object operation.
Description
Description of the Twitter data object operation.

Column Properties

The column properties lists the datatypes, precision, and scale of the source transformation.
The following table describes the column properties that you can view for a Twitter data object operation:
Property
Description
Name
Name of the Twitter data object operation.
Type
Transformation datatype of the metadata.
Precision
Maximum number of significant digits for numeric datatypes, or maximum number of characters for string datatypes. For numeric datatypes, precision includes scale.
Scale
Maximum number of digits after the decimal point for numeric values.
Description
Description of the Twitter data object operation.

Advanced Properties

The advanced properties lists the resource physical name of the source transformation.

Ports Properties

The ports properties lists the datatypes, precision, and scale of the Input transformation.
The following table describes the ports properties that you can view for a Twitter data object operation:
Property
Description
Name
Name of the metadata such as FollowersCount, FriendsCount, and Username of the resource.
Type
Datatype of the metadata.
Precision
Maximum number of characters for string datatypes.
Description
Description of the metadata.

Sources Properties

The sources properties lists the resources of the Input transformation.
The following table describes the sources properties that you configure for a Twitter data object operation:
Property
Description
Sources
List of the Twitter resources in the data object operation. You can add or delete resources.

Advanced Properties

The advanced properties includes the run-time properties of the Input transformation. You can specify the search criteria to extract Twitter data in the query parameter. When you run the mapping, the Data Integration Service uses the search criteria to extract Twitter data.
The following table describes the advanced properties that you configure for a Twitter data object operation:
Property
Description
Query Parameter
Twitter search criteria. You can specify the Twitter search criteria based on the resource. Each resource requires one of the following mandatory parameters:
  • screen_name
  • user_id
  • QUERY
For example, you specify the screen name in the following query parameter to extract the Twitter profile of the Twitter screen name Rinnovator:
screen_name=Rinnovator
Token File
File name and format of a file that contains a list of access tokens and access secrets. The CSV file must be on the machine where Informatica Services is installed. The Data Integration Service uses the access token and access secret at run time to establish a connection. If one set of access token and access secret fails, the Data Integration Service uses the next set. Review the session log for details.
Specify the fully qualified path and format of the file in one of the following formats:
  • <file path>;{accesstoken,accesssecret}
    or
    <file path>
    Use one of the formats if the file contains only the mandatory comma-separated columns of access token and access secret.
  • <file path>;{col1,accesstoken,accesssecret,col4}
    Use this format to specify optional columns such as col1 and col4. For example,
    \\hostname\OAuth\tw_tokens.csv;{accesstoken,accesssecret,ID,name}
     specifies the location of a file named tw_tokens.csv that contains the following mandatory comma-separated columns: accesstoken and accesssecret. The Data Integration Service ignores the optional columns, ID and name, at run time.
Ends After
Twitter pagination property. Controls the number of rows requested. Specify a time or a positive numeral:
  • Amount of time that the Data Integration Service runs the mapping. Enter the duration in the following format: hh:mm
    Default is blank, which indicates that the Data Integration Service runs the mapping until you stop it or until there is data.
  • Number of rows that are requested. The Data Integration Service will request the minimum number of rows which is 100. The maximum number of rows requested is based on the rows returned by the Twitter application. Enter the number of rows as a positive numeral.
Configure for the Search resource.
0 COMMENTS
We’d like to hear from you!