Page History
...
Options | Description |
---|---|
Source Table | Identifies the source table where the column's data comes from. This source table is normally a load table, or a dimension table within the data warehouse. If the column was sourced from multiple tables, then the normal practice is to record one of the tables in this field and a comment listing all of the other tables in the Source strategy field. This field is used when generating a procedure to update the stage table. It is also used in the trackback diagrams and in the documentation. |
Source Column | Identifies the source column where the column's data comes from. Such a column is normally a load table column, which in turn may have been a transformation or the combination of multiple columns. This may also be a dimensional key where a dimension is being joined. |
Source Data Type | Identifies the source column's data type. [Read-only]. |
Transformation | Refer to Dimension Column Transformations for details. [Read-only]. |
Join | Indicates whether the table column is used in a table join. [Normally maintained automatically but can be optionally changed to override the default join logic used in the generated update procedure]. The Source table and Source column fields will provide the dimension table's side of the join. The options for this field are: False, True, Manual and Pre Join.
|
...