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
- 53255 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / ajit dada pawar
fact table is one which contains all the facts
.aggregate table is one which is created after
the cube is processed.this aggregate table contains human
unreadable text.
| Is This Answer Correct ? | 1 Yes | 10 No |
Post New Answer View All Answers
What is the difference between aggregate table and materialized view?
Explain what are components of report studio?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What are aggregate transformation?
Explain what are the steps to build the data warehouse?
Describe the differences between a data warehouse and data mart.
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What do you mean by static and local variable?
What are algorithms provided by Microsoft in SQL Server?
Give some difference between oltp and olap.
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
Explain what are the various file formats involved in reportnet?
How much data hold in one universe.
Explain what is a three tier data warehouse?
