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

HTTP ERROR 404 Not Found

URI:/content/informaticadita-com/en_us/integration-cloud/cloud-mass-ingestion/current-version/_mass-ingestion_cloud-mass-ingestion_current-version_ditamap/mass_ingestion_databases/mass_ingestion_databases_targets_-_usage_considerations/amazon_redshift_targets/_jcr_content/header/menupage.nocache.html/informaticadita-com/components/content/menu-hover
STATUS:404
MESSAGE:Not Found
SERVLET:org.apache.felix.http.base.internal.dispatch.DispatcherServlet-592afdc7
English
  •        
  • Data Ingestion and Replication
  • Current Version
  • Mass Ingestion
    • Error 404 Not Found

    HTTP ERROR 404 Not Found

    URI:/content/informaticadita-com/en_us/integration-cloud/cloud-mass-ingestion/current-version/_mass-ingestion_cloud-mass-ingestion_current-version_ditamap/mass_ingestion_databases/mass_ingestion_databases_targets_-_usage_considerations/amazon_redshift_targets/_jcr_content/navigation-bar/breadcrumb/timestamp.nocache.html/informaticadita-com/components/content/timestamp
    STATUS:404
    MESSAGE:Not Found
    SERVLET:org.apache.felix.http.base.internal.dispatch.DispatcherServlet-592afdc7
  • Data Ingestion and Replication
  • All Products

Table of Contents

Search

  1. Introducing Mass Ingestion
  2. Getting Started with Mass Ingestion
  3. Connectors and Connections
  4. Mass Ingestion Applications
  5. Mass Ingestion Databases
  6. Mass Ingestion Files
  7. Mass Ingestion Streaming
  8. Monitoring Mass Ingestion Jobs
  9. Asset Management
  10. Troubleshooting

Mass Ingestion

Mass Ingestion

Back Next

Amazon Redshift targets

Amazon Redshift targets

The following list identifies considerations for preparing and using Amazon Redshift targets:
  • Before writing data to Amazon Redshift target tables, database ingestion jobs stage the data in an Amazon S3 bucket. You must specify the name of the bucket when you configure the database ingestion task. The ingestion jobs use the
    COPY
     command to load the data from the Amazon S3 bucket to the Amazon Redshift target tables. For more information about the
    COPY
     command, see the Amazon Web Services documentation.
  • When you define a connection for an Amazon Redshift target, provide the access key and secret access key for the Amazon S3 bucket in which you want the database ingestion jobs to stage the data before loading it to the Amazon Redshift target tables.
  • Incremental load jobs and combined initial and incremental load jobs generate a recovery table named INFORMATICA_CDC_RECOVERY on the target to store internal service information. The data in the recovery table prevents jobs that are restarted after a failure from propagating previously processed data again. The recovery table is generated in the same schema as the target tables.
0 COMMENTS
We’d like to hear from you!