Table of Contents

Search

  1. Preface
  2. Part 1: Getting Started with Snowflake Data Cloud Connector
  3. Part 2: Data Integration with Snowflake Data Cloud Connector
  4. Part 3: SQL ELT with Snowflake Data Cloud Connector
  5. Appendix A: Data type reference
  6. Appendix B: Additional runtime configurations
  7. Appendix C: Upgrading to Snowflake Data Cloud Connector

Snowflake Data Cloud Connector

Snowflake Data Cloud Connector

Optimize the write operation in a CDC mapping

Optimize the write operation in a CDC mapping

You can optimize the write operation in a mapping that reads from a CDC source and writes to a Snowflake target.
To optimize the write operation, set the JVM option to
-DSNOWFLAKE_CDC_PARALLEL_EXECUTION=true
for the Secure Agent.
  1. Log in to Informatica Intelligent Cloud Services.
  2. Select
    Administrator
    Runtime Environments
    .
  3. On the
    Runtime Environments
    page, select the Secure Agent machine that runs the mapping.
  4. Click
    Edit
    .
  5. In the
    System Configuration Details
    section, select
    Data Integration Server
    as the service and
    DTM
    as the type.
  6. Edit the JVM option, and set the value to
    -DSNOWFLAKE_CDC_PARALLEL_EXECUTION=true
    .
    The configured JVMOption property for the Secure Agent.
  7. Click
    Save
    .

0 COMMENTS

We’d like to hear from you!