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
- 53545 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
In a star schema, are foreign key constraints between facts and dimensions neccessary?
How to add a number to a macro variable?
What is the difference between drill through and masterdetail reports?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
What is core dimension?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
What are session timeout and application timeout?
What is the difference between snowflake and star schema?
What is conformed fact?
How can you communicate with web server (apache or iis) from coldfusion?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
What is the use of tabular model, tabular sql, tabular reference in real time application?
How can we schedule the graph in unix?
What are the steps of implementing data warehousing?
