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
- 53984 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
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
What is the purpose of Dataware Control?
Explain what is full load & incremental or refresh load?
How to pivot data using informatica when you have variable amount of pivot rows?
What are the mapping paramaters and maping variables?
What is informatica architecture?
What is the use of dimensional modeling in data warehousing?
explain about balanced dimension,
Name a few sectors which use data warehousing?
How do we design a universe?
Explain the hierarchies level data warehousing.
How can we run the graph? How can we schedule the graph in unix?
What is meant by metadata in context of a data warehouse?
How can we schedule the graph in unix?
How to calculate fact table granularity?
