For information on the structure of the workbook and the fact table, see the related links at the bottom of the page.
In the data warehouse, each dimension is defined to store the surrogate key of the dimension record. You can specify the data source ID and natural key of the artifacts in the source data. During the ETL process, the specified values are loaded and transformed to the surrogate key of the records in the data warehouse. You must specify the natural key for dimensions that represent an independent artifact, and in the control table, you must specify the column name of the table in the operational data source that corresponds to the natural key of the artifact. For dimensions representing simple values such as state and priority, you can specify the values directly.