Data Warehouse
Some Natures of Fact Tables In DWH: 1.Fact tables can be factless. Fact table can be with no “measures”. The Fact table can be an intersection of “dimension” 2.There are some junk dimensions. Like “yes” or ‘no” columns. They may be needed in the source table for the OLTP application functionality. But they are NOT …