Interested to Buy Any Domain ? << Click Here >> for more details...
Is snow flake or star schema used?
If star schema means why?
- 4 Answers
- 9420 Views
- CTS, Sonata, I also Faced
- E-Mail Answers
Answer Posted / venkat
In the aboue two (snow flake,star)schemas ,star schema is
best,because star schema is denormalised and star schema is
centrally located Fact table and surrounded by multiple
dimention tables.so fact table size can be calculated based
on the lowest level granularity of the dimentions.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What the difference is between a database, a data warehouse and a data mart?
Explain sessions and how many types of sessions are there?
What does command task mean?
What is status code in informatica?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is the procedure for creating independent data marts from informatica 7.1?
what is the size of your data warehousing?
How can we use mapping variables in informatica? Where do we use them?
what are the deliverables?in your project?
How to do the error handling of if ur source is flatfiles?
What you know about transaction control transformation?
What is a node in Informatica?
What is a grid in Informatica?
What is lookup transformation?
What is the Rank index port in Rank transformation?
