Skip to main content

Fact changes dimension table

Table Name

Column Name

Column Type

Primary Key

Mapped Dimension Table

Mapped Dimension Table Column

Bi_DimFactChanges_s3

ETLFactChangeID

DECIMAL(19,0)

PK

 

 

Bi_DimFactChanges_s3

FactPk

DECIMAL(19,0)

 

 

 

Bi_DimFactChanges_s3

FactName

NVARCHAR(512)

 

 

 

Bi_DimFactChanges_s3

CreatedOnDate

TIMESTAMP

 

 

 

Bi_DimFactChanges_s3

FactId

SMALLINT

 

 

 

Bi_DimFactChanges_s3

GroupId

DECIMAL(19,0)

 

 

 

Bi_DimFactChanges_s3

PodName

VARCHAR(20)

 

 

 

Bi_DimFactChanges_s3

OrganizationId

VARCHAR(36)