Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.
Not Found
English

Page Not Found

The page or file you are looking for has been moved or no longer exists.

The following links might help you find the content you need:


You can also search the Documentation Portal or visit the home page.

English
  • Data Integration Connectors
  • All Products

Table of Contents

Search

  1. Part 1: Introduction to Amazon Redshift connectors
  2. Part 2: Data Integration with Amazon Redshift V2 Connector
  3. Part 3: Data Integration with Amazon Redshift Connector

Amazon Redshift Connectors

Amazon Redshift Connectors

Back Next

Rules and guidelines for the direct read mode

Rules and guidelines for the direct read mode

Consider the following rules and guidelines when you read directly from an Amazon Redshift source:
  • The order of data written to the target in the direct read mode is different from the order of data written after Amazon S3 staging.
  • The precision values are rounded-off to the 6
    th
     precision for real data types and to the 14
    th
     precision for double data types.
  • NULL values in char and varchar data types are written to the target without quotes.
  • Trailing spaces in the char data type columns appear with trailing spaces in the target. In comparison, the trailing spaces are truncated when you set the source with staging mode.
0 COMMENTS
We’d like to hear from you!