Table of Contents

Search

  1. Preface
  2. Introduction to Data Engineering Streaming
  3. Data Engineering Streaming Administration
  4. Sources in a Streaming Mapping
  5. Targets in a Streaming Mapping
  6. Streaming Mappings
  7. Window Transformation
  8. Appendix A: Connections
  9. Appendix B: Monitoring REST API Reference
  10. Appendix C: Sample Files

Cassandra, ODBC, and Transformation Data types

Cassandra, ODBC, and Transformation Data types

When you import a Cassandra column family as a data object, the transformation data types corresponding to the ODBC data types appear in the Developer Tool.
The Informatica Cassandra ODBC driver reads Cassandra data and converts the Cassandra data types to ODBC data types. The Data Integration Service converts the ODBC data types to transformation data types.
The following table lists the Cassandra data types and the corresponding ODBC and transformation data types:
Cassandra Data Types
ODBC Data Types
Transformation Data Types
ASCII
Varchar
Varchar
Bigint
Bigint
Bigint
Blob
Varbinary
Varbinary
Boolean
Bit
Bit
Date
Date
Datetime
Decimal
Decimal
Decimal
Double
Double
Double
Float
Real
Real
Inet
Varchar
Varchar. Cassandra Inet data type supports IP addresses in IPv4 and IPv6 formats. Informatica Cassandra ODBC driver does not support reading or writing IP addresses in IPv6 format.
Int
Integer
Integer
Smallint
Smallint
Integer
Text
Wvarchar
Varchar
Timestamp
Varchar
Time stamp. The Informatica Cassandra ODBC driver treats the Time stamp data type values in Coordinated Universal Time (UTC) format.
Range of Timestamp value is 1601-01-01 00:00:00.000 to 9999-12-31 23:59:59.999
Timeuuid
Varchar
Varchar
Tinyint
Tinyint
Integer
Uuid
Varchar
Varchar. When you use comparison operators in data of Uuid data type, enclose values of Uuid data type within single quotation marks. For example, in the following query, the value for the Uuid data type is enclosed within single quotation marks:
DELETE from pc.map_nesting_tgt_vt_col_map2 where pc.map_nesting_tgt_vt_col_map2.col_uuid='152d2030-14e6-11e4-aef1-fd88d8253a43';
Varchar
Varchar
Varchar
Varint
Numeric
Numeric
The Varint data type is stored internally as Long data type in the Spark execution plan.