what is the difference between aggregate table and fact
table ? how do you load these two tables ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Explain what is a three tier data warehouse?
Where the cache files stored?
5.Explain ODS ?
Difference between slicing and dicing with example?
if we increase the number of dimensions will the rows in fact table increase or decrease??
if you use oracle sql*loader , how do you transform data with it during loading?
After the complete generation of a report who will test the report and who will analyze it?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
What is surrogate key?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
What is surrogate key? Where we use it?
Explain about core dimension, balanced dimension, and dirty dimension?