Hi,
I am not sure what you mean by "Candidate Check".
You can get a description of a fact table using the following links:
http://en.wikipedia.org/wiki/Fact_tablehttp://en.wikipedia.org/wiki/Online_analytical_processingIf you need additional explanation feel free to ask.
Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro