A surrogate key is none business key. it can be a sequential number with no business meanings. these are useful for the underlying applications to maintain relationships between tables.Routines are th...
Factless Fact Table is the fact table without having any measure (Transaction Data).The intention may vary from use but mostly its used for either Custom Reporting or Bridging.
It contains only the k...
Best way of explaining the purpose of factless fact table is factless fact tables are the prefered method of recording evernts in a data warehouse where there is no natural numberic measurement associated with the event.