Common Content for Data Engineering
- Common Content for Data Engineering 10.5.7
- All Products
Property
| Description
|
|---|---|
Name
| The column name.
|
Datatype
| The data type for the data in each column. You can select one of the following data types:
You cannot create a managed reference table from an Oracle table that uses a number data type if the data type does not specify values for precision and scale.
|
Precision
| The precision for each column. Precision is the maximum number of digits or the maximum number of characters that the column can accommodate.
The precision values you configure depend on the data type.
|
Scale
| The scale for each column. Scale is the maximum number of digits that a column can accommodate to the right of the decimal point. Applies to decimal columns.
The scale values you configure depend on the data type.
|
Description
| An optional description for each column.
|
Nullable
| Indicates if the column can contain null values.
|
Key
| Identifies a primary key column in a table that you import from a database source.
If you update an unmanaged reference table, you cannot add duplicate values to a column that originates from a primary key column in the source database. You can add duplicate values to any column in a managed reference table.
|