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
- 53633 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / chithra. k
Fact tables generally contains measures and the composite
key, which is generally a combination of foreign keys from
the respective dimension tables.
Aggregate tables are summary tables which contains the
summary information say for eg:total sales revenue (for a
quarter).
So the difference is in the granularity.Fact tables store
date in more detail level, but in aggregate tables the
granularity is high.
| Is This Answer Correct ? | 18 Yes | 2 No |
Post New Answer View All Answers
Explain the different types of data warehousing?
What is data analytics in simple terms?
Explain what are the mapping paramaters and maping variables?
Explain how many ways you create ports?
What is the difference between filter and lookup transformation?
Explain a mapping, session, worklet, workflow, mapplet?
How to add a number to a macro variable?
Explain what are the advantages and disadvantages of reporting directly against the database?
Explain what is the difference between powerplay transformer and power play reports?
Explain what are the vaious etl tools in the market?
Explain difference between e-r modeling and dimentional modeling?
I need to set predefined condition. How I do this?
Explain can a dimension table contains numeric values?
What are steps we have to follow in designing the userfriendly universe?
what are the other factors of the database on which the loading performance depend?
