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
- 13611 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
How do you generate sequence number in datastage?
CHANGE CAPTURE
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What is difference between join, merge and lookup stage?
Name the different sorting methods in datastage.
Explain Quality stage?
How do you schedule or monitoring the job?
How do you run datastage job from the command line?
What is difference between symmetric multiprocessing and massive parallel processing?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What are the primary usages of datastage tool?
Explain connectivity between datastage with datasources?
How do you import and export the datastage jobs?
What is datastage?
What are stage variables and constants?
