what is the difference between aggregate table and fact
table ? how do you load these two tables ?
Answer Posted / azhar
hi,
The difference might be in the granularity level....
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
Explain how to get the first 100 rows from the flat file into the target?
What is data analysis?
Explain bus schema?
What is the difference between mapping parameter & mapping variable in data warehousing?
Why is business intelligence (bi) important in data warehousing?
Explain what is partitioning? What are the types of partitioning?
What is perform recovery?
What are Non-additive facts?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What are aggregate tables and aggregate fact tables?
What is prompt types of prompts?use of prompts syntax of prompt?
What is the use of tabular model, tabular sql, tabular reference in real time application?
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?
Tell me what is degree of a relation?
What are target types on the server?