fact table has measures and aggregated data .Aggregate table has only aggr

what is the difference between aggregate table and fact
table ? how do you load these two tables ?

Question Posted / nethaji

Answer Posted / nethaji

fact table has measures and aggregated data .Aggregate table
has only aggregate value (ie) precalculated value.

Is This Answer Correct ?

3 Yes

9 No

Please Help Members By Posting Answers For Below Questions

What is meant by metadata in context of a data warehouse and how it is important?

1269

What is surrogate key? Explain with examples.

1221

Can you pass sql queries in filter transformation?

1066

Explain is fact table?

973

What is mean by aggregate aware?

1155

For faster process, what we will do with the universe?

1032

Where the cache files stored?

1063

What is a junk dimension? What is the difference between junk dimension and degenerated dimension?

971

Explain what is a three tier data warehouse?

1033

Difference between cold fusion mx 6 and cold fusion mx 7?

886

What is type 2 version dimension?

1019

What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

1110

What is application.cfm?

1114

Describe a data warehouse.

1030

What is surrogate key? Where we use it explain with example?

971