Interested to Buy Any Domain ? << Click Here >> for more details...
Why should we use star schema in datawarehouse design?
- 2 Answers
- 5948 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / arun
Star schema has less joins within its related dimensions so query retreival is faster than SNow-flake.
Space consumed is more than snow-flake
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Briefly define reusable transformation?
What are the main features of Oracle 8i with context to datawarehouse?
Explain lookup transformation source types in informatica
How can you increase the performance in joiner transformation?
What is status code in informatica?
What is sequence generator transformation in informatica?
What is the meaning of decode in informatica?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What are the transformations that are not supported in mapplet?
Can you use flat files in Mapplets.
what is the hint? how to use it to reduce the query processing in program?
what are factless facts? And in which scenario will you use such kinds of fact tables.
How does a rank transform differ from aggregator transform functions max and min?
How can you differentiate between powercenter and power map?
