what is the difference between aggregate table and fact
table ? how do you load these two tables ?
Answer Posted / plaban
The main difference is the type of involvement in Schema
| Is This Answer Correct ? | 1 Yes | 12 No |
Post New Answer View All Answers
Where the data cube technology is used?
What are components of reportnet?
What is data warehouse architecture?
What is the difference between aggregate table and materialized view?
What are the different types of data warehouses?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
What is difference macros and prompts?
Explain meta data?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
What are non-additive facts in detail?
What is called data cleaning?
What is load manager?
How to join 3 database like flat file, oracle, db2 in informatrica?
What are the types of dimensional modeling?
How much data hold in one universe.