what is the difference between aggregate table and fact
table ? how do you load these two tables ?
- 12 Answers
- 51163 Views
- Target, I also Faced
- E-Mail Answers
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
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
What are diagrams?
Do you view contain data?
List down some of the real time data-warehousing tools?
What is loop in data warehousing?
What is a cube in data warehousing concept?
Explain what is the metadata extension?
What are partition points?
What are necessary tasks to install reportnet software?
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 is difference macros and prompts?
What is degenerate dimension table?
What are vaious etl tools in the market?
I have two universes created by two difference database can we join them in designer & report level? How
what are relationships?
