Cassandra V2 Connector > Mappings with Cassandra V2 > Cassandra V2 sources in mappings
  

Cassandra V2 sources in mappings

To read data from Cassandra, configure a Cassandra V2 object as a Source transformation in a mapping in advanced mode.
Specify the name and description of the Cassandra V2 source. When you configure a Source transformation, you can add or remove source fields of primitive data types.
The following table describes the source properties that you can configure for a Cassandra V2 source:
Property
Description
Connection
Name of the Cassandra V2 source connection.
You can select an existing connection or create a new connection. You can also click New Parameter to define a parameter for the source connection.
Source Type
Type of the source object.
Select one of the following options:
  • - Single Object
  • - Multiple Objects
  • - Parameter
Default is Single Object.
Object
Name of the Cassandra V2 source object based on the selected source type.
Select the source object for a single source.
When you select the multiple source option, you can add multiple source objects and configure a relationship between them.
The following table describes the query option that you can configure for a Cassandra V2 source:
Property
Description
Select distinct rows
Applies to Single object and Parameter.
Select this option to read only distinct rows.
The following table describes the advanced source properties that you can configure for a Cassandra V2 source:
Property
Description
Tracing Level
Sets the amount of detail that appears in the log file.
Select one of the following options:
  • - Terse
  • - Normal
  • - Verbose initialization
  • - Verbose
Default is Normal.

Adding and removing source fields

You can configure the source fields that you want to use in the data flow.
You can add fields to a mapping source and retrieve a field from the source object that is not displayed in the list. To add a field, click This image allows you to add fields to a mapping source., and then enter the field name, type, precision, and scale. You can also remove fields that you do not want to use in the mapping. To remove a field, select the field and then click This image allows you to remove fields from the source object..
This image displays the options to add and remove source fields.