Interested to Buy Any Domain ? << Click Here >> for more details...
Discuss the advantages & Disadvantages of star & snowflake
schema?
- 5 Answers
- 46724 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
Is it possible to use a client with different version than that of its Informatica server?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is the commit type if you have a transaction control transformation in the mapping?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is an unconnected transformation?
How to load a Dimension ? and how to load a fact table?
What does refresh system mean, and what are its distinctive choice?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Differences between version 7.x and 8.x.
Explain the pipeline partition with real time example?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How many ways are there to do 'remove duplicate records in informatica'?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Global and Local shortcuts. Advantages.
What is olap (on-line analytical processing?
