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
- 53534 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
what are the different views that are considered when building an object-oriented software system?
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 what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Difference between cold fusion 5 and cold fusion mx 6?
Explain what are the mapping paramaters and maping variables?
Explain datawarehousing?
Explain can a dimension table contains numeric values?
What are data modeling and data mining? Where it will be used?
What is a staging area? Do we need it? What is the purpose of a staging area?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
How to stop a batch?
explain about balanced dimension,
what are the all possible features supported modify stage?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
What is the difference between aggregate table and materialized view?
