ETL_METADATA
This table stores ETL metadata, such as stream and version information. This table is under the schema that contains metadata.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
Field Name |
Null? |
Field Type |
Field Description |
---|---|---|---|
OBJECT_ID |
Not Null |
int |
Object ID |
OBJECT_NAME |
Not Null |
Varchar(200) |
Entity name or stream name |
OBJECT_TYPE |
Nullable |
Varchar(100) |
The following types are supported:
|
FILE_CONTENT |
Nullable |
Varchar(50000) |
Entire metadata file content |
CONTENT_PACK_ID |
Not Null |
int |
Content pack ID |
SOURCE_PRODUCT |
Not Null |
Varchar(50) |
Source product name, such as PPM |
VERSION |
Not Null |
Varchar(20) |
Version defined in metadata |
METADATA_LAYOUT_VERSION |
Nullable |
Varchar(20) |
Metadata file layout version |
MD_CREATETIME |
Nullable |
datetime |
Date when the record is created |
MD_LASTMODDDATE |
Nullable |
datetime |
Date when the record is updated |
Projections
This table uses no projections.
Sequences
This table uses no sequences.