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
- 53998 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
Explain what are the vaious etl tools in the market?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What is the definition of cube in datawarehousing?
What is the difference between static cache and dynamic cache?
What are templates in which way it is help full?
What are different deliverables according to phases?
Suggest a good author for hyperion in data warehousing?
What are snapshots? What are materialized views & where do we use them?
What are the data types present in bo?
What is the difference between dependent data warehouse and independent data warehouse?
Which component has onread method and what it is used for?
Explain what is a cube in data warehousing concept?
What is data warehosuing hierarchy?
Why facts table is useful in representing the data?
