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
- 53587 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / jayalakshmi
fact table is one which contains all the facts
(measures).aggregate table is one which is created after
the cube is processed.this aggregate table contains human
unreadable text.
| Is This Answer Correct ? | 14 Yes | 50 No |
Post New Answer View All Answers
What are the possible data marts in retail sales?
What are the key features of chameleon that separates it from other algorithms?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
Define data warehouse?
How to create prompts in report net?
Explain the difference between view and materialized view?
Explain what are the advantages data mining over traditional approaches?
How can we run the graph? How can we schedule the graph in unix?
What is a source qualifier?
How to know the time taken for particular report execution?
What is the difference between er modeling and dimensional modeling?
Store (and count) non-fact records?
Explain what are data marts?
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?
List any five applications of data warehouse.
