The difference between DIM, TCAT, FACT and DISC tables in the Publish database are :
1. The tables starting with DIM are the dimension tables used in the analysis.
2. The tables starting with FACT are the fact tables used in the analysis.
3. The tables starting with DISC are the data source data tables used to store discovered data from the Normalize task.
4. The tables starting with TCAT are for Technopedia data.