This report lists the origins of 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 check box unchecked, then the results screen is as follows, showing the line of origins for the selected tables:
If however, you selected Exclude Intermediate Steps, then the results screen is as follows, showing only the source table for the selected tables:
The results of this report are displayed as a list of source tables and columns, the order of the result set determining the immediate lineage. The report includes the following columns:
- Tables (the name of a selected table)
- Columns (the name of a selected column)
- Source Tables
- Source 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 on the result set and click Output to File to send the results of this report to Microsoft Excel.