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.
- 1Log in to Informatica Intelligent Cloud Services.
- 2Select Administrator > Runtime Environments.
- 3On the Runtime Environments page, select the Secure Agent machine that runs the mapping.
- 4Click Edit.
- 5In the System Configuration Details section, select Data Integration Server as the service and DTM as the type.
- 6Edit the JVM option, and set the value to -DSNOWFLAKE_CDC_PARALLEL_EXECUTION=true.
- 7Click Save.