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
- 53535 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
What are the various file formats involved in reportnet?
What are data modeling and data mining?
Explain multivalued dependency?
How many types of facts and what are they?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
Explain difference between view and materialized view?
what is difference between drill & scope of analysis?
Explain the difference between data ware house & data mart?
What is is a star schema?
Explain me what are conformed dimensions?
What are target types on the server?
What are cluster analysis in data warehousing?
Explain what are the various reporting tools in the market?
What is analytical or analytic mean?
Code the tables statement to produce a multi-level frequency?
