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
- 13805 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
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Can you explain how could anyone drop the index before loading the data in target in datastage?
What is usage analysis in datastage?
Explain how a source file is populated?
what is the custome stage in datastage? how can we impliment that one? plz tell me
How many types of stage?
What is staging variable?
How do you import and export the datastage jobs?
What is the difference between informatica and datastage?
whom do you report?
Differentiate between operational datastage (ods) and data warehouse?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Could anyone give brief explanation bout datastage admin
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What is process model?
