A Detail Fact table is typically created by dragging a staging table onto a fact table list. Once released, the dialog to create the fact table will commence.
When a staging table is dragged into the drop target pane (middle pane), all Fact tables are by default Detail Fact tables.
If manually creating a table, then the table type can be selected from the Properties window of the Fact table.
Detail Fact Columns
The columns for a Detail Fact table are typically those of the staging table. Such Fact tables typically contain a wide range of measures and attributes as well as the business keys used to look up the artificial dimension keys.
These business keys should be included whenever possible as they provide a means of rebuilding the dimensional link. If size prohibits their inclusion it is probably necessary to backup or archive all source data to ensure that the Fact table can be rebuilt.
These Fact tables normally contain a large number of attributes such as dates, which have not been converted to dimensions. Also contained would be information, such as order numbers, invoice numbers etc.