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
- 13811 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / chand
Star Schema is best choice...most of the project use star
schema. performance wise star schema is best.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / pavan
star schema is better than snow flake schema bcz star
schema maintained the denormalization its means allow
duplicates so i can say star schema is good
| Is This Answer Correct ? | 2 Yes | 0 No |
What are the various kinds of containers available in datastage?
I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?
If you want to use the same piece of code in different jobs, how will you achieve it?
i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?
what is ds administrator used for?
what are the different type of errors in datastage?
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?
what is the difference between the join and look up explin me one exmple
How to add zero "0" before record in a field?
How do y read Sequential file from job control?
how can we do null handling in sequential files
What is a quality stage in datastage tool?
Teradata 
