what is the difference between aggregate table and fact
table ? how do you load these two tables ?
Answer Posted / ajit dada pawar
fact table is one which contains all the facts
.aggregate table is one which is created after
the cube is processed.this aggregate table contains human
unreadable text.
| Is This Answer Correct ? | 1 Yes | 10 No |
Post New Answer View All Answers
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
Explain what are components of reportnet?
What are Aggregate tables?
Explain meta data?
Explain piconet?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
Explain me what is vldb?
What is the purpose of cluster analysis in data warehousing?
Explain the difference between data ware house & data mart?
What are universe requirements?
Explain what are the different types of data warehousing?
What is analytical or analytic mean?
What are Non-additive facts?
Explain what are the advantages and disadvantages of reporting directly against the database?
What is crass reference table?