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:

  • SOURCE
  • TARGET
  • EXT
  • STREAM

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.