Preface
Introduction to PowerExchange for Google BigQuery
PowerExchange for Google BigQuery Configuration
- PowerExchange for Google BigQuery Configuration Overview
- Registering the PowerExchange for Google BigQuery Plug-in
  - Registering the PowerExchange for Google BigQuery Plug-in from the Administrator Tool
  - Registering the PowerExchange for Google BigQuery Plug-in from the Command Line Program
Google BigQuery Sources and Targets
Google BigQuery Mappings
- Google BigQuery Mappings Overview
- Source Filter
  - Configuring a Source Filter
Google BigQuery Sessions
Google BigQuery as CDC Target
Google BigQuery Pushdown Optimization
Appendix A: Google BigQuery Data Type Reference
- Data Type Reference Overview
- Google BigQuery and Transformation Data Types

PowerExchange for Google BigQuery User Guide for PowerCenter

10.5.8
- 10.5.9
- 10.5.7
- 10.5.6

Back Next

Create a Mapping

If the PowerExchange Express CDC for Oracle source contains rows flagged with insert, update, delete, upsert operations, drag the imported object to the Mapping Designer and design your logic based on source columns.

If the rows in the PowerExchange Express CDC for Oracle source are not flagged with required operations, use the Update Strategy transformation to flag the rows for insert, update, delete, or upsert operation as required.

You must define a key column in the Google BigQuery target definition. While reading from a CDC source, you must define and map the key column in the CDC source to key column in the Google BigQuery target object. Else, the session fails.

Rename Saved Search

Table of Contents

PowerExchange for Google BigQuery User Guide for PowerCenter

PowerExchange for Google BigQuery User Guide for PowerCenter

Create a Mapping

Create a Mapping