what is the difference between aggregate table and fact
table ? how do you load these two tables ?
- 12 Answers
- 49732 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
a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
Explain what is the data type of the surrogate key?
What are the stages of datawarehousing?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
Difference between cold fusion mx 6 and cold fusion mx 7?
Explain what are the different methods of loading dimension tables?
Explain why denormalization is promoted in universe designing?
What are the different types of schemas used in data warehousing?
How can we determine what records to extract?
What are modeling tools available in the market?
Difference between e-r modeling and dimentional modeling?
How can you clear the cache?
What are steps we have to follow in designing the userfriendly universe?
What is the difference between drill through and masterdetail reports?
