fact and dimension

maniram23 — Thu, 23 Apr 2015 06:03:26 GMT

hi experts,

what is fact and dimension table with neat diagram. what are the differences?

Re: fact and dimension

prma7799 — Thu, 23 Apr 2015 06:11:26 GMT

Hi Mani,

Dimension tables contain attributes that describe fact records in the fact table. Some of these attributes provide descriptive information; others are used to specify how fact table data should be summarized to provide useful information to the analyst. Dimension tables contain hierarchies of attributes that aid in summarization. For example, a dimension containing product information would often contain a hierarchy that separates products into categories such as food, drink, and nonconsumable items, with each of these categories further subdivided a number of times until the individual product SKU is reached at the lowest level.

Fact table captures the data that measures the organization's business operations. A fact table might contain business sales events such as cash register transactions or the contributions and expenditures of a nonprofit organization.

A key characteristic of a fact table is that it contains numerical data (facts) that can be summarized to provide information about the history of the operation of the organization.

PFA

Thanks

topic fact and dimension in QlikView

fact and dimension

Re: fact and dimension