Star Schema vs. Snow Flake Schema. What is the best model
for DW? Give example for both the models performance wise?
- 3 Answers
- 12360 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 |
How to implement complex jobs in data stage?
30 jobs are running in unix.i want to find out my job.how to do this?Give me command?
table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?
Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,
sed,awk,head
How can we improve performance of data stage jobs?
What is the use of hoursfromtime() function in transformer stage in datastage?
How you Remove the Dataset in Unix?
What is a merge in datastage?
i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?
what are the devoleper roles in real time? plz tell i am new to datastage....
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Teradata 
