what is the difference between aggregate table and fact
table ? how do you load these two tables ?
Answer Posted / surya
Aggregate tables also known as summary tables, are fact
tables which contain data that has been summarized up to
different level(Month level, year level) of detail
aggregation.
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
What are fact, dimension, and measure?
What are the different ways to represent the loading of dimension tables?
What are non-additive facts in detail?
Explain the differences between normalizer and normalizer transformation?
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
Explain the difference between filter and conditin?
Where the applications and where
Explain the difference between keylokup and joiner?
What is ods (operation data source)?
Give some difference between oltp and olap.
What is the difference between ods and oltp?
Can we take backup when the database is opened?
What is the difference between junk dimension and degenerated dimension?
Explain the data type of the surrogate key?
What is the use of dimensional modeling in data warehousing?