Cross-Reference Tables
Cross-reference tables are tables in the repository that are referenced by the Build Catalog Metadata Wizard when you update the source objects and create the catalog. These tables should be filled up prior to running the Build Catalog Metadata Wizard.
Cross-reference tables can be filled up using the structure below:
|
Table |
Columns |
Data Type |
Description |
|---|---|---|---|
|
CR_CatalogObjects |
DataSourceReference |
varchar(200) |
Data Source System Name Note:
The Data Source Reference should match the source system name in DWD Designer. |
|
PhysicalTableName |
varchar(200) |
Source Table Name |
|
|
CatalogTableName |
varchar(200) |
Source Table Description and object name in the Catalog |
|
|
TableType |
varchar(40) |
Category of the Source object (blank for default) |
|
|
IsHidden |
bit |
0 – Visible 1 – Not Visible |
|
|
CR_CatalogAttributes |
DataSourceReference |
varchar(200) |
Data Source System Name Note:
The Data Source Reference should match the source system name in DWD Designer. |
|
PhysicalTableName |
varchar(200) |
Source Table name |
|
|
PhysicalColumnName |
varchar(200) |
Source Column name |
|
|
CatalogColumnName |
varchar(200) |
Source Column Description and column name in the Catalog |
|
|
IsKey |
char(1) |
K – Key N – Non-key |
|
|
IsMandatory |
char(1) |
Y – Mandatory N – Not Mandatory |
|
|
OverrideDataType |
varchar(200) |
New Data Type (blank for no change) |
|
|
OverridePrecision |
int |
New Data Type Precision (blank for no change) |
|
|
OverrideScale |
int |
New Data Type Scale (blank for no change) |
|
|
OverrideSourceCalcRule |
varchar(6000) |
Calculation name of the source column referenced to CR_CalculationRules |
|
|
OverrideCatalogCalcRule |
varchar(6000) |
Calculation name of the catalog column referenced to CR_CalculationRules |
|
|
CR_CalculationRules |
CalculationName |
nchar(50) |
Calculation name which can be referenced from CR_CalculationAttributes columns OverrideSourceCalcRule and OverrideCatalogCalcRule |
|
CalculationRule |
nvarchar(max) |
Calculation column value Note:
The string pattern |