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
  • Informatica Data Quality 10.4.0
  • All Products

Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.4.0
  3. Part 2: Version 10.2.2
  4. Part 3: Version 10.2.1
  5. Part 4: Version 10.2
  6. Part 5: Version 10.1.1
  7. Part 6: Version 10.1

Release Guide

Release Guide

Back Next

PowerExchange for Amazon Redshift

PowerExchange for Amazon Redshift

Effective in version 10.2.2, PowerExchange for Amazon Redshift includes the following features:
  • You can read data from or write data to the following regions:
    • China(Ningxia)
    • EU(Paris)
  • You can use Amazon Redshift objects as dynamic sources and target in a mapping.
  • You can use octal values of printable and non-printable ASCII characters as a DELIMITER or QUOTE.
  • You can enter pre-SQL and post-SQL commands to run queries for source and target objects in a mapping.
  • You can define an SQL query for read data objects in a mapping to override the default query. You can enter an SQL statement supported by the Amazon Redshift database.
  • You can specify the maximum size of an Amazon S3 object in bytes when you download large Amazon S3 objects in multiple parts.
  • You can read unique values when you read data from an Amazon Redshift source.
  • When you upload an object to Amazon S3, you can specify the minimum size of the object and the number of threads to upload the objects in parallel as a set of independent parts.
  • You can choose to retain an existing target table, replace a target table at runtime, or create a new target table if the table does not exist in the target.
  • You can configure the Update Strategy transformations for an Amazon Redshift target in the native environment.
  • When you write data to Amazon Redshift, you can override the Amazon Redshift target table schema and the table name during run time.
  • When the connection type is ODBC, the Data Integration Service can push transformation logic to Amazon Redshift sources and targets using source-side and full pushdown optimization.
  • You can use Server-Side Encryption with AWS KMS (AWS Key Management Service) on Amazon EMR version 5.16 and Cloudera CDH version 5.15 and 5.16.
  • PowerExchange for Amazon Redshift supports AWS SDK for Java version 1.11.354.
For more information, see the
Informatica PowerExchange for Amazon Redshift 10.2.2 User Guide
.
0 COMMENTS
We’d like to hear from you!