Star Schema vs. Snow Flake Schema. What is the best model
for DW? Give example for both the models performance wise?
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
AGGREGATOR default datatype
Can you explain kafka connector?
What is the use of datastage designer?
how to add a new records into source?
How to reverse the string using SQL?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Why do we use exception activity in Datastage?
What are the different kinds of views available in a datastage director?
Define project in datastage?
What are the main differences you have observed between 7.x and 8.x version of datastage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is job control?
Differentiate between datastage and datastage tx?
Lookup constraints
What is the purpose of pivot stage?