What are the 3 benefits to having Facts?
- Report Developers don't need to worry about the Data Warehouse structure.
- The Data Warehouse can contain differently named columns of the same data.
- No need to resolve discrepancies in the Data Warehouse.
What does the Fact Creation Wizard allow you to do?
Automatically create Basic (Homogeneous, Simple) Facts only.
What are Fact Column Aliases?
They are the name and type of the columns used in SQL temp tables. Sometimes it can cause problems when a Fact contains columns of multiple data types.