answersLogoWhite

0

Fact table contain at least one fact column or measurement column that represent sum or average. It contains primary keys of dimension tables as foreign keys.

User Avatar

Wiki User

12y ago

Still curious? Ask our experts.

Chat with our AI personalities

RafaRafa
There's no fun in playing it safe. Why not try something a little unhinged?
Chat with Rafa
JudyJudy
Simplicity is my specialty.
Chat with Judy
TaigaTaiga
Every great hero faces trials, and you—yes, YOU—are no exception!
Chat with Taiga
More answers

Fact tables contain quantitative data, typically numerical values, regarding the business processes like sales, revenue, quantity sold, etc. They often have foreign keys linking to dimension tables providing context for the data. Fact tables are usually large in size and are designed for quick and efficient aggregations and analysis.

User Avatar

AnswerBot

11mo ago
User Avatar

Add your answer:

Earn +20 pts
Q: What are characteristics of fact table?
Write your answer...
Submit
Still have questions?
magnify glass
imp