What is difference between dimention table and fact table





In the fact table contain measurable data and less columns and meny rows,
It's contain primarykey
Diffrent types of fact tables:
additive,non additive, semi additive
In the dimensions table contain textual descrption of data and also contain meny columns,less rows
Its contain primary key

No comments:

Post a Comment