Import the PowerExchange Express CDC for Oracle source from which you want to read the data. The imported object appears in the

Source Analyzer

.

Create a connection object to connect to the PowerExchange Express CDC for Oracle source in the

Workflow Manager

. When creating a connection for the CDC source, you can configure the connection attributes, such as idle time, maximum rows per commit, and minimum rows per commit. When you configure the connection in the session properties, the PowerCenter Integration Service uses this connection to connect to the CDC source.

Similarly, create or import the Google BigQuery target object to write data. The imported object appears in the

Target Designer

. Create a connection object to connect to the Google BigQuery target object in the

Workflow Manager

After importing the objects, create a mapping with the required transformations.