This report lists the columns derived from the selected objects.
Objects Included
The following WhereScape RED object types are included in this report:
- Load Tables
- Stage Tables
- Dimension Tables and Views
- Fact Tables
- Aggregate Tables
- Exports
- Hubs, Satellites and Links
Parameters
- Groups
- Projects
- Table
- Column
Results
If you left the Exclude Intermediate Steps checkbox unchecked then the results screen is as follows, showing the impacted tables for the selected tables:
If however, you selected Exclude Intermediate Steps then the results screen is as follows, showing only the final impacted table for the selected tables:
The results of this report are displayed as a list of impacted tables and columns, the order of the result set determining the immediate impact. The report includes the following columns:
- Tables (the names of selected tables)
- Columns (the names of selected columns)
- Impact Tables
- Impact Columns
The result set is not sortable, as the order of the result set determines the immediate lineage.
Sending Results to Microsoft Excel
Right-click the result set and click Output to File to send the results of this report to Microsoft Excel.