Discuss the advantages & Disadvantages of star & snowflake
schema?
- 5 Answers
- 45001 Views
- I also Faced
- E-Mail Answers
Answer Posted / alhad kulkarni
The question is Advantages and Disadvantages, not What is
Star or Snowflake.
Star Adv: Reduced Joins, Faster Query Operation.
Snow Adv: Distributed data, Easier to obtain fact-less data
e.g. Orders Shipped across one Quarter.
Star DisAdv: Bigger table sizes, Too many rows in Fact Table
Snow DisAdv: More number of joins, Slower Query operation,
| Is This Answer Correct ? | 78 Yes | 1 No |
Post New Answer View All Answers
In development project what is the process to follow for an etl developer from day1
What is meant by query override?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Why union transformation is an active transformation?
Global and Local shortcuts. Advantages.
4 yrs etl devloper roles and responsibilities?any body give solutions
What is a rank transform?
How can you differentiate between powercenter and power map?
What is joiner change?
How to do unit testing in informatica? How to load data in informatica ?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Why do we need informatica?
Explain Dataware house architecture .how data flow from intial to end?
Can we create a node as a gateway node and the same node can be assigned to a grid?
