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
- 53077 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 are data mart and dwh normalized or denormalized? Do both of them exist in
Explain what are data marts?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
Explain how are the dimension tables designed?
What are situations where snowflake schema is better than star schema when the opposite is true?
Which are the olap tools available that are supported by oracle?
Explain difference between view and materialized view?
Explain what are slowly changing dimensions?
What is Active Datawarehousing?
What is index awareness in universe?
What is the definition of cube in datawarehousing?
What are target types on the server?
What is the difference between power center and power mart?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
