Star Schema vs. Snow Flake Schema. What is the best model
for DW? Give example for both the models performance wise?
- 3 Answers
- 12704 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / 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 |
Lookup constraints
What are transforms and what is the differenece between routines and transforms?
How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?
what is usage of datastage with materialized views
wt is the diff b/w odbc and oracle stage
what is datastage job Monitoring
can explain wt is the pool for file.
parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
How many types of sorting methods are available in datastage?
What are the functionalities of link partitioner?
I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?
Teradata 
