Page History
...
| Fields | Description |
|---|---|
| Source Table | Identifies the source table where the column's data comes from. This source table is normally a fact 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 aggregate 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 fact table column or a dimension table column, which in turn may have been a transformation or a combination of multiple columns. |
| Source Data Type | Identifies the source column's data type. [Read-only]. |
| Transformation | Refer to Aggregate 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 dimension 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. |
...