Interested to Buy Any Domain ? << Click Here >> for more details...
Star Schema vs. Snow Flake Schema. What is the best model
for DW? Give example for both the models performance wise?
- 3 Answers
- 13961 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / ram
star schema is better
it will maintain denormalised data and also query
performance is faster because it having less relationships
between the tables
but in snowflake schema it is opposite
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
What is a quality stage in datastage tool?
How many types of views are there in a datastage director?
Can you implement SCD2 using join, transformer and funnel stage?
How you Implemented SCD Type 1 & Type 2 in your project?
What are datastage sequences?
What are stage variables?
Differentiate between validated and Compiled in the Datastage?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What is difference between symmetric multiprocessing and massive parallel processing?
Is the value of staging variable stored temporarily or permanently?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Explain Quality stage?
What is the difference between orabulk and bcp stages?
How to reverse the string using SQL?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
