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 SAS
  3. PowerExchange for SAS Installation and Configuration
  4. SAS Connections
  5. SAS Data Objects
  6. SAS Run-Time Processing
  7. SAS Data Types Reference
  8. SPI Server Configuration Parameters
  9. SAS Error Messages

PowerExchange for SAS User Guide

PowerExchange for SAS User Guide

Back Next

Input Properties of a Data Object Write Operation

Input Properties of a Data Object Write Operation

The input properties represent the data that the Data Integration Service passes into the mapping pipeline. Select the input properties to edit the port properties of the data object write operation. You can also specify advanced data object write operation properties to load data into SAS data sets.
The input properties of the data object write operation include general properties that apply to the data object write operation. They also include port, source, and advanced properties that apply to the data object write operation.
You can view and change the input properties of the data object write operation from the
General
,
Ports
,
Sources
, and
Advanced
 tabs.

General Properties

The general properties list the name and description of the data object write operation.

Ports Properties

The input ports properties list the data types, precision, and scale of the data object write operation.
You can configure the following input ports properties in a data object write operation:
Name
Name of the port.
Type
Data type of the port.
Precision
Maximum number of significant digits for numeric data types or maximum number of characters for string data types. For numeric data types, precision includes scale.
Scales
Maximum number of digits after the decimal point for numeric values.
Description
Description of the port.

Targets Properties

The target properties list the SAS data sets in the data object write operation.

Advanced Properties

The advanced properties allow you to specify the data object write operation properties to load data into SAS data sets.
You can configure the following advanced properties in the data object write operation:
Load Type
Configure the load type for the target.
Trace
Boolean property to implement the SAS trace option. Use the SAS trace option to toggle verbose logging.
Compress
Boolean property to implement the SAS compress option. When you enable the SAS compress option, target SAS data sets will be stored with compressed content.
PreSASCode and PostSASCode
Facilitates the invocation of a SAS Macro or a SAS %include statement to be executed just before or just after the loading of the SAS target object. The SPI Server must be configured to allow the execution of SAS exits. The SAS Macro to be invoked must be defined in the autoexec.sas file that is part of the SPI Server configuration.
Index Name (For Update Strategy)
Name of the index that defines the composite key to be used for the load type 'update-else-insert'. This option is used only in the case of a composite key.
0 COMMENTS
We’d like to hear from you!