what is the difference between aggregate table and fact
table ? how do you load these two tables ?
- 12 Answers
- 51168 Views
- Target, I also Faced
- E-Mail Answers
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
How to create prompts in report net?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
how much memory space occupied real time project (roughly)?
What is a cube in data warehousing concept?
What is latest version of power center / power mart?
Code the tables statement to produce a multi-level frequency?
How to stop a batch?
What is data validation strategies for data mart v?
What are universe requirements?
Explain what are the advantages of query studio compared to report studio?
What is surrogate key? Where we use it explain with example?
Why we use repository connectivity?
What is the goal of optimizer?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
