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

Tell me what is degree of a relation?

997

What are target types on the server?

995

What is surrogate key? Where we use it? Explain with examples.

1027

Where the applications and where

929

What are the advantages of raid 1, 1/0, and

980

Explain piconet?

964

What are data validation strategies for data mart validation after loading process?

1017

What are templates in which way it is help full?

996

what are different storage options supported by oracle ?

2092

Explain ddl (data definition language)?

1008

Why fact table is in a normal form?

991

List down some of the real time data-warehousing tools?

974

What is dimensional modelling?

986

Difference between cold fusion 5 and cold fusion mx 6?

996

What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

949