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
- 53542 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / nethaji
fact table has measures and aggregated data .Aggregate table
has only aggregate value (ie) precalculated value.
| Is This Answer Correct ? | 3 Yes | 9 No |
Post New Answer View All Answers
Explain what is the difference between stop and abort?
Explain datawarehousing?
What are the steps involved in creating dimensional modeling process?
Is union transormation is active transformation?
Could any one explain me how to create cascading prompts?
How can we load the time dimension?
What are the types of dimensional modeling?
Explain what is a view as it relates to system modeling?
Explain what is the difference between a primary and secondary actor in use case modeling?
How can we do data cleaning?
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 a junk dimension? What is the difference between junk dimension and degenerated dimension?
What is cfapplication tag?
What is the difference between view materialized view and view?
Explain the definition of normalized and denormalized view and what are the differences between them?
