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

Explain a mapping, session, worklet, workflow, mapplet?

1053

Explain about core dimension, balanced dimension, and dirty dimension?

958

Explain some of modeling tools available in the market?

912

Explain what are fact, dimension, and measure?

940

Explain can a dimension table contains numeric values?

930

Explain what is the metadata extension?

989

What is the difference between star and snowflake schemas?

1133

Can a dimension table contain numeric values?

1017

Give some difference between oltp and olap.

973

What is data cleaning? How can we do that?

998

How to define a cube??

886

What is the use of dimensional modeling in data warehousing?

934

Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?

929

I have two universes created by two difference database can we join them in designer & report level? How

930

What is difference macros and prompts?

2237