Difference between base fact table and aggregate fact table ?
4 posters
Page 1 of 1
Difference between base fact table and aggregate fact table ?
Hi I am new to data warehouse.
I want to ask two questions.
1) What is the difference between base fact table and aggregate fact table. I will appreciate if anyone explain it with example.
2) I have designed source schema (ER). Now I want to design dimensional model, what primary keys should be of each dimension ?
Thanks
I want to ask two questions.
1) What is the difference between base fact table and aggregate fact table. I will appreciate if anyone explain it with example.
2) I have designed source schema (ER). Now I want to design dimensional model, what primary keys should be of each dimension ?
Thanks
pokemon- Posts : 2
Join date : 2012-11-21
Re: Difference between base fact table and aggregate fact table ?
Go here:
http://www.kimballgroup.com/data-warehouse-and-business-intelligence-resources/kimball-core-concepts/
http://www.kimballgroup.com/data-warehouse-and-business-intelligence-resources/kimball-core-concepts/
TheNJDevil- Posts : 68
Join date : 2011-03-01
Re: Difference between base fact table and aggregate fact table ?
Thanks but I could not get answer of my question-1 :-(
pokemon- Posts : 2
Join date : 2012-11-21
Re: Difference between base fact table and aggregate fact table ?
From Dictionary.com:
ag·gre·gate [adj., n. ag-ri-git, -geyt; v. ag-ri-geyt]
adjective
1. formed by the conjunction or collection of particulars into a whole mass or sum; total; combined: the aggregate amount of indebtedness.
2. Botany .
a.(of a flower) formed of florets collected in a dense cluster but not cohering, as the daisy.
b.(of a fruit) composed of a cluster of carpels belonging to the same flower, as the raspberry.
3. Geology . (of a rock) consisting of a mixture of minerals separable by mechanical means.
An aggregate fact table is one made up of data from other fact tables.
ag·gre·gate [adj., n. ag-ri-git, -geyt; v. ag-ri-geyt]
adjective
1. formed by the conjunction or collection of particulars into a whole mass or sum; total; combined: the aggregate amount of indebtedness.
2. Botany .
a.(of a flower) formed of florets collected in a dense cluster but not cohering, as the daisy.
b.(of a fruit) composed of a cluster of carpels belonging to the same flower, as the raspberry.
3. Geology . (of a rock) consisting of a mixture of minerals separable by mechanical means.
An aggregate fact table is one made up of data from other fact tables.
Re: Difference between base fact table and aggregate fact table ?
ngalemmo wrote:From Dictionary.com:
ag·gre·gate [adj., n. ag-ri-git, -geyt; v. ag-ri-geyt]
adjective
1. formed by the conjunction or collection of particulars into a whole mass or sum; total; combined: the aggregate amount of indebtedness.
2. Botany .
a.(of a flower) formed of florets collected in a dense cluster but not cohering, as the daisy.
b.(of a fruit) composed of a cluster of carpels belonging to the same flower, as the raspberry.
3. Geology . (of a rock) consisting of a mixture of minerals separable by mechanical means.
An aggregate fact table is one made up of data from other fact tables.
Appreciate this one.Thanks.
hunypowell- Posts : 1
Join date : 2012-11-25
Similar topics
» Calculated measure value in aggregate fact table
» Location and population dim/fact
» Why not snowflake if the aggregate dimension is needed for a different fact table?
» Daily net sales - single aggregate fact table or calculate from two
» Replacing Aggregate dimension with Conformed base dimension at lowest level.
» Location and population dim/fact
» Why not snowflake if the aggregate dimension is needed for a different fact table?
» Daily net sales - single aggregate fact table or calculate from two
» Replacing Aggregate dimension with Conformed base dimension at lowest level.
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum