Informatica Developer uses the following data types in HBase mappings:
HBase native data types. HBase data types appear in the physical data object column properties.
Although data is stored in binary format in HBase tables, you can specify the data type associated with a column when you create the HBase data object.
Transformation data types. Set of data types that appear in the transformations. They are internal data types based on ANSI SQL-92 generic data types, which the Data Integration Service uses to move data across platforms. Transformation data types appear in all transformations in a mapping.
When the Data Integration Service reads source data, it converts the native data types to the comparable transformation data types before transforming the data. When the Data Integration Service writes to a target, it converts the transformation data types to the comparable native data types.