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

Relational Data Object Overview Properties

Relational Data Object Overview Properties

The Data Integration Service uses overview properties when it writes data to a relational data object.
The Overview properties include general properties that apply to the relational data object. They also include column properties that apply to the resources in the relational data object.

General Properties

The following table describes the general properties that you configure for relational data objects:
Property
Description
Name
Name of the relational data object.
Description
Description of the relational data object.

Column Properties

The following table describes the column properties that you can view for relational data objects:
Property
Description
Name
Name of the column.
Native Type
Native data type of the column.
Precision
Maximum number of significant digits for numeric data types, or maximum number of characters for string data types. For numeric data types, precision includes scale.
Scale
Maximum number of digits after the decimal point for numeric values.
Description
Description of the column.
Nullable
Indicates if the column can contain null values.
Primary Key
Identifies a primary key column in a table that you import from a database source.

Advanced Properties

Advanced properties include run-time and other properties that apply to the relational data object. The Developer tool displays advanced properties for relational data object in the
Advanced
view.
Property
Description
Connection
Name of the Hive connection.
Owner
Name of the resource owner.
This property is not applicable for Hive sources and targets.
Resource
Name of the resource.
Database Type
Type of the source.
This property is read-only.
Resource Type
Type of the resource.
This property is read-only.