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
- 53982 Views
- Target, I also Faced
- E-Mail Answers
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?
Teradata 
