Star Schema vs. Snow Flake Schema. What is the best model
for DW? Give example for both the models performance wise?
- 3 Answers
- 12321 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between account and directory options ?
What are the important features of datastage?
Name the third party tools that can be used in datastage?
Whats difference betweeen operational data stage (ods) and data warehouse?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What is the difference between the local container and shared container?
How do you import and export data into datastage?
How to perform incremental load in datastage?
How one source columns or rows to be loaded in to two different tables?
What are the processing stages?
What are the stages in datastage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
How and where you used hash file?
How can you write parallel routines in datastage PX?
