Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Google Cloud Spanner
  3. PowerExchange for Google Cloud Spanner Configuration
  4. Google Cloud Spanner Connections
  5. PowerExchange for Google Cloud Spanner Data Objects
  6. PowerExchange for Google Cloud Spanner Mappings
  7. Google Cloud Spanner Run-Time Processing
  8. Appendix A: Google Cloud Spanner Data Type Reference

PowerExchange for Google Cloud Spanner User Guide

PowerExchange for Google Cloud Spanner User Guide

Google Cloud Spanner Data Object Write Operation

Google Cloud Spanner Data Object Write Operation

Create a mapping to write data to Google Cloud Spanner. Use the Google Cloud Spanner connection, and define the write operation properties to write data to Google Cloud Spanner.
You can perform insert, update, delete, and upsert operations on a Google Cloud Spanner target.
To perform a update, delete, or upsert operation, you must add an Update Strategy transformation to a mapping and flag the records in an update strategy expression.
When you run a mapping on the Spark engine, you cannot add an Update Strategy transformation. Hence, you cannot perform update, delete, or upsert operations on a Google Cloud Spanner target when you run a mapping on the Spark engine.
For more information about configuring an Update Strategy transformation, see "Update Strategy Transformation" in the
Informatica Developer Transformation Guide
.

0 COMMENTS

We’d like to hear from you!