Interested to Buy Any Domain ? << Click Here >> for more details...
Discuss the advantages & Disadvantages of star & snowflake
schema?
- 5 Answers
- 46818 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
Explain about Informatica server process that how it works relates to mapping variables?
Explain in detail about scd type 1 through mapping.
What is the use of target designer?
How to call shell scripts from informatica?
How to use pmcmd utility command?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is informatica metadata and where is it stored?
What is the cumulative sum and moving sum?
How to use procedural logic inside infromatica?
How can we delete duplicate rows from flat files?
How to update a particular record in target with out running whole workflow?
Differentiate between sessions and batches?
Do you find any difficulty while working with flat files as source and target?
Where do we use mapping variables in informatica?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
