Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between aggregate table and fact
table ? how do you load these two tables ?
- 12 Answers
- 53057 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / santosh
The difference that i know is that the aggregate tables
contain only the summaries of the data where as the fact
tables contain summaries and measures. i.e.,the grain of
the data present in fact table is more than the grain of
the data present in aggregate tables.
| Is This Answer Correct ? | 15 Yes | 5 No |
Post New Answer View All Answers
What are the various transformation available?
What are universe requirements?
What are the difference between snow flake and star schema?
Difference between cold fusion 5 and cold fusion mx 6?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
Explain differences between star and snowflake schemas?
How to limit the max no of rows retrieved in the report?
Explain what is data validation strategies for data mart validation after loading process?
What are templates in which way it is help full?
Explain what are the mapping paramaters and maping variables?
Where the applications and where ware house management system is used?
What is index awareness in universe?
What is a hash cluster?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
Start a batches with in a batch?
