Page History
...
| Field | Description |
|---|---|
| Source Table | Identifies the source table where the column's data comes from. This source table is normally a load 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 EDW 3NF table. It is also used in the trackback diagrams and 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. For previous value-managed columns, the source column is the column in the table whose previous value is being recorded. |
| Source Data Type | Identifies the source column's data type. [Read-only]. |
| Transformation | Refer to EDW 3NF Table Column Transformations. [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 other EDW 3NF table's side of the join. The options for this field are: False, True, Manual, and Pre-Join.
|
| Pre Join Source Table | Indicates the table from which the pre-joined column was sourced. When the Join option is set to False, this field becomes inactive. When the Join option is set to True or Manual, this field is set to the current table name. When the Join option is set to Pre Join, then you can select the required table from the drop-down list. |
...