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
- 13599 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
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What are iconv and oconv?
What are data elements?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What is the use of datastage designer?
table actions available in oracle connector?
whom do you report?
What is the difference between operational data stage (ods) and data warehouse?
If you want to use a same piece of code in different jobs, how will you achieve this?
how to abort the job its matain duplicates?
How and where you used hash file?
Differentiate between operational datastage (ods) and data warehouse?
How many types of views are there in a datastage director?
On which interface you will be working as a developer?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
