Star Schema vs. Snow Flake Schema. What is the best model
for DW? Give example for both the models performance wise?
- 3 Answers
- 12322 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
Explain connectivity between datastage with datasources?
What is the difference between the local container and shared container?
What is the difference between in process and inter process?
what is the use of skid in reporting?
what is flow of project?
Lookup constraints
What are the components of ascential data stage?
What is use Array size in datastage
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
how can we create rank using datastage?what is the meaning of rank?
Explain datastage architecture?
why do u need the IOS upgradation in a FC switch
How a source file is populated?
What is ibm datastage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
