You can configure a custom SQL query to configure a Google BigQuery source.

You can configure a SQL override to override the default SQL query used to extract data from the Google BigQuery source.

You can specify a quote character that defines the boundaries of text strings in a .csv file. You can configure parameters such as single quote or double quote.

You can configure full pushdown optimization to push the transformation logic to Google BigQuery when you use the ODBC connection type.

You can import a Kafka source or target definition in Avro format.

You can configure SSL configuration properties to securely connect to Kafka.

You can preview data of a Kafka source or target definition.

You can use custom queries when you read a source object.

You can override the source object and the source object schema in the source session properties. The source object and the source object schema defined in the source session properties take the precedence.

You can override the target object and the target object schema in the target session properties. The target object and the target object schema defined in the target session properties take the precedence.

You can create a mapping to read the real-time or changed data from a Change Data Capture (CDC) source and load data into Microsoft Azure SQL Data Warehouse. You must select

Data Driven

as the target operation to capture changed data. You can resume the extraction of changed data from the point of interruption when a mapping fails or is stopped before completing the session.

To enhance the performance, you can compress staging files in the .gzip format when you write to a target object.

You can use version 43.0, 44.0, and 45.0 of Salesforce API to create a Salesforce connection and access Salesforce objects.

You can enable primary key chunking for queries on a shared object that represents a sharing entry on the parent object. Primary key chunking is supported for shared objects only if the parent object is supported. For example, if you want to query on CaseHistory, primary key chunking must be supported for the parent object Case.

You can create assignment rules to reassign attributes in records when you insert, update, or upsert records for Lead and Case target objects using the standard API.

You can parameterize the Salesforce service URL for standard and OAuth connection.

You can configure the PowerCenter Integration Service to write rejected records to a rejected file. If the file already exists, the PowerCenter Integration Service appends the rejected records to that file. If you do not specify the rejected file path, the PowerCenter Integration Service does not write the rejected records.

You can use an Update Strategy transformation in a mapping to insert, update, delete, or reject data in Snowflake targets. When you configure an Update Strategy transformation, the

Treat Source Rows As

session property is marked

Data Driven

by default.

You can use the SQL editor to create or edit the pre-SQL and post-SQL statements in the Snowflake source and target sessions.