what is the difference between aggregate table and fact
table ? how do you load these two tables ?
Answer Posted / sandeep
the following points are differ from fact table desiging
summary table :
1. use of intelligent key or non - intelligent key
2.use of abbrevatons decoded on the fly
3.use of embedded refernce keys
4.which columns to include that is vertical partitioning
strategy
5.horizontal partitioning strategy
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Which columns go to the fact table and which columns go the dimension table?
What is data warehouse architecture?
How did you plan your Data ware house project?
Explain what are the various methods of getting incremental records or delta records from the source systems?
List down some of the real time data-warehousing tools?
What is data validation strategies for data mart v?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
What is analytical or analytic mean?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
Can you state some of the innovations throughout history?
What is the difference between aggregate table and materialized view?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
What is difference between model & package?
How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?
What is the 4 + 1 view model as it relates to system modeling?