Star Schema vs. Snow Flake Schema. What is the best model
for DW? Give example for both the models performance wise?
Answer Posted / 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 |
Post New Answer View All Answers
Difference between sequential file and data set?
What is oci?
How can we improve the performance in datastage?
What is staging variable?
What are some different alternative commands associated with "dsjob"?
Define ds designer?
What are the enhancements made in datastage 7.5 compare with 7.0?
What is the difference between Datastage 7.5 and 7.0?
What is datastage?
CHANGE CAPTURE
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Differentiate between validated and Compiled in the Datastage?
On which interface you will be working as a developer?
What are the some differences between 7.x and 8.x version of datastage?
What is quality stage?