Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between aggregate table and fact
table ? how do you load these two tables ?
- 12 Answers
- 53615 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
Explain can a dimension table contains numeric values?
What are the advantages and disadvantages of reporting directly against the database?
Explain what is the difference between a primary and secondary actor in use case modeling?
What do you mean by static and local variable?
Store (and count) non-fact records?
Why should we use data ware housing and how can you extract data for analysis with example?
What is a functional dependency f said to be minimal?
Explain bus schema?
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?
Why facts table is useful in representing the data?
What are the possible data marts in retail sales?
Can you pass sql queries in filter transformation?
What is the difference between power center and power mart?
Can a dimension table contain numeric values?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
