PowerExchange for Google BigQuery User Guide for PowerCenter

Back Next

Create a Session

After you create a mapping in the Designer, you create a session in the

Workflow Manager

In a session, you define properties that determine how the PowerCenter Integration Service extracts data from or loads data to the data source.

Configure the following session properties in the

Properties

tab:

Treat source rows as

. Select Data driven.

Commit on End of File

. Deselect the check box.

Commit Type

. Select Source.

Recovery Strategy

. Select Resume from last checkpoint.

Configure the following source session properties in the

Mapping

tab:

Connections

. Select the PowerExchange for Oracle CDC real-time source connection to access the PowerExchange Express CDC for Oracle source.

Configure the following target session properties in the

Mapping

tab:

Connections

. Select the PowerExchange for Google BigQuery connection to access the Google BigQuery target.

Write Mode

. Select CDC.

After the session is created, run the session.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.